{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('ETH_1h.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-13 08-PM</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.94</td>\n",
       "      <td>131.82</td>\n",
       "      <td>126.87</td>\n",
       "      <td>128.71</td>\n",
       "      <td>1940673.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-13 07-PM</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>119.51</td>\n",
       "      <td>132.02</td>\n",
       "      <td>117.10</td>\n",
       "      <td>129.94</td>\n",
       "      <td>7579741.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2020-03-13 06-PM</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.47</td>\n",
       "      <td>124.85</td>\n",
       "      <td>115.50</td>\n",
       "      <td>119.51</td>\n",
       "      <td>4898735.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>2020-03-13 05-PM</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.08</td>\n",
       "      <td>127.42</td>\n",
       "      <td>121.63</td>\n",
       "      <td>124.47</td>\n",
       "      <td>2753450.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>2020-03-13 04-PM</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.85</td>\n",
       "      <td>129.51</td>\n",
       "      <td>120.17</td>\n",
       "      <td>124.08</td>\n",
       "      <td>4461424.71</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Date  Symbol    Open    High     Low   Close      Volume\n",
       "0  2020-03-13 08-PM  ETHUSD  129.94  131.82  126.87  128.71  1940673.93\n",
       "1  2020-03-13 07-PM  ETHUSD  119.51  132.02  117.10  129.94  7579741.09\n",
       "2  2020-03-13 06-PM  ETHUSD  124.47  124.85  115.50  119.51  4898735.81\n",
       "3  2020-03-13 05-PM  ETHUSD  124.08  127.42  121.63  124.47  2753450.92\n",
       "4  2020-03-13 04-PM  ETHUSD  124.85  129.51  120.17  124.08  4461424.71"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(23674, 7)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2020-03-13 08-PM'"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[0,'Date']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'str' object has no attribute 'day_name'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-6-8b4d6a935df8>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mdf\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mloc\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m0\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;34m'Date'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mday_name\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m: 'str' object has no attribute 'day_name'"
     ]
    }
   ],
   "source": [
    "df.loc[0,'Date'].day_name()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['Date'] = pd.to_datetime(df['Date'],format='%Y-%m-%d %I-%p')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       2020-03-13 20:00:00\n",
       "1       2020-03-13 19:00:00\n",
       "2       2020-03-13 18:00:00\n",
       "3       2020-03-13 17:00:00\n",
       "4       2020-03-13 16:00:00\n",
       "                ...        \n",
       "23669   2017-07-01 15:00:00\n",
       "23670   2017-07-01 14:00:00\n",
       "23671   2017-07-01 13:00:00\n",
       "23672   2017-07-01 12:00:00\n",
       "23673   2017-07-01 11:00:00\n",
       "Name: Date, Length: 23674, dtype: datetime64[ns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Date']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Friday'"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[0,'Date'].day_name()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "d_parser = lambda x: pd.datetime.strptime(x,'%Y-%m-%d %I-%p')\n",
    "df = pd.read_csv('ETH_1h.csv',parse_dates=['Date'],date_parser=d_parser)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-13 20:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.94</td>\n",
       "      <td>131.82</td>\n",
       "      <td>126.87</td>\n",
       "      <td>128.71</td>\n",
       "      <td>1940673.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-13 19:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>119.51</td>\n",
       "      <td>132.02</td>\n",
       "      <td>117.10</td>\n",
       "      <td>129.94</td>\n",
       "      <td>7579741.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2020-03-13 18:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.47</td>\n",
       "      <td>124.85</td>\n",
       "      <td>115.50</td>\n",
       "      <td>119.51</td>\n",
       "      <td>4898735.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>2020-03-13 17:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.08</td>\n",
       "      <td>127.42</td>\n",
       "      <td>121.63</td>\n",
       "      <td>124.47</td>\n",
       "      <td>2753450.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>2020-03-13 16:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.85</td>\n",
       "      <td>129.51</td>\n",
       "      <td>120.17</td>\n",
       "      <td>124.08</td>\n",
       "      <td>4461424.71</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Date  Symbol    Open    High     Low   Close      Volume\n",
       "0 2020-03-13 20:00:00  ETHUSD  129.94  131.82  126.87  128.71  1940673.93\n",
       "1 2020-03-13 19:00:00  ETHUSD  119.51  132.02  117.10  129.94  7579741.09\n",
       "2 2020-03-13 18:00:00  ETHUSD  124.47  124.85  115.50  119.51  4898735.81\n",
       "3 2020-03-13 17:00:00  ETHUSD  124.08  127.42  121.63  124.47  2753450.92\n",
       "4 2020-03-13 16:00:00  ETHUSD  124.85  129.51  120.17  124.08  4461424.71"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       2020-03-13 20:00:00\n",
       "1       2020-03-13 19:00:00\n",
       "2       2020-03-13 18:00:00\n",
       "3       2020-03-13 17:00:00\n",
       "4       2020-03-13 16:00:00\n",
       "                ...        \n",
       "23669   2017-07-01 15:00:00\n",
       "23670   2017-07-01 14:00:00\n",
       "23671   2017-07-01 13:00:00\n",
       "23672   2017-07-01 12:00:00\n",
       "23673   2017-07-01 11:00:00\n",
       "Name: Date, Length: 23674, dtype: datetime64[ns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Date']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0          Friday\n",
       "1          Friday\n",
       "2          Friday\n",
       "3          Friday\n",
       "4          Friday\n",
       "           ...   \n",
       "23669    Saturday\n",
       "23670    Saturday\n",
       "23671    Saturday\n",
       "23672    Saturday\n",
       "23673    Saturday\n",
       "Name: Date, Length: 23674, dtype: object"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Date'].dt.day_name()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['DayOfWeek'] = df['Date'].dt.day_name()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>DayOfWeek</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-13 20:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.94</td>\n",
       "      <td>131.82</td>\n",
       "      <td>126.87</td>\n",
       "      <td>128.71</td>\n",
       "      <td>1940673.93</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-13 19:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>119.51</td>\n",
       "      <td>132.02</td>\n",
       "      <td>117.10</td>\n",
       "      <td>129.94</td>\n",
       "      <td>7579741.09</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2020-03-13 18:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.47</td>\n",
       "      <td>124.85</td>\n",
       "      <td>115.50</td>\n",
       "      <td>119.51</td>\n",
       "      <td>4898735.81</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>2020-03-13 17:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.08</td>\n",
       "      <td>127.42</td>\n",
       "      <td>121.63</td>\n",
       "      <td>124.47</td>\n",
       "      <td>2753450.92</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>2020-03-13 16:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.85</td>\n",
       "      <td>129.51</td>\n",
       "      <td>120.17</td>\n",
       "      <td>124.08</td>\n",
       "      <td>4461424.71</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>23669</td>\n",
       "      <td>2017-07-01 15:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>265.74</td>\n",
       "      <td>272.74</td>\n",
       "      <td>265.00</td>\n",
       "      <td>272.57</td>\n",
       "      <td>1500282.55</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>23670</td>\n",
       "      <td>2017-07-01 14:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>268.79</td>\n",
       "      <td>269.90</td>\n",
       "      <td>265.00</td>\n",
       "      <td>265.74</td>\n",
       "      <td>1702536.85</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>23671</td>\n",
       "      <td>2017-07-01 13:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>274.83</td>\n",
       "      <td>274.93</td>\n",
       "      <td>265.00</td>\n",
       "      <td>268.79</td>\n",
       "      <td>3010787.99</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>23672</td>\n",
       "      <td>2017-07-01 12:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>275.01</td>\n",
       "      <td>275.01</td>\n",
       "      <td>271.00</td>\n",
       "      <td>274.83</td>\n",
       "      <td>824362.87</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>23673</td>\n",
       "      <td>2017-07-01 11:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>279.98</td>\n",
       "      <td>279.99</td>\n",
       "      <td>272.10</td>\n",
       "      <td>275.01</td>\n",
       "      <td>679358.87</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23674 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Date  Symbol    Open    High     Low   Close      Volume  \\\n",
       "0     2020-03-13 20:00:00  ETHUSD  129.94  131.82  126.87  128.71  1940673.93   \n",
       "1     2020-03-13 19:00:00  ETHUSD  119.51  132.02  117.10  129.94  7579741.09   \n",
       "2     2020-03-13 18:00:00  ETHUSD  124.47  124.85  115.50  119.51  4898735.81   \n",
       "3     2020-03-13 17:00:00  ETHUSD  124.08  127.42  121.63  124.47  2753450.92   \n",
       "4     2020-03-13 16:00:00  ETHUSD  124.85  129.51  120.17  124.08  4461424.71   \n",
       "...                   ...     ...     ...     ...     ...     ...         ...   \n",
       "23669 2017-07-01 15:00:00  ETHUSD  265.74  272.74  265.00  272.57  1500282.55   \n",
       "23670 2017-07-01 14:00:00  ETHUSD  268.79  269.90  265.00  265.74  1702536.85   \n",
       "23671 2017-07-01 13:00:00  ETHUSD  274.83  274.93  265.00  268.79  3010787.99   \n",
       "23672 2017-07-01 12:00:00  ETHUSD  275.01  275.01  271.00  274.83   824362.87   \n",
       "23673 2017-07-01 11:00:00  ETHUSD  279.98  279.99  272.10  275.01   679358.87   \n",
       "\n",
       "      DayOfWeek  \n",
       "0        Friday  \n",
       "1        Friday  \n",
       "2        Friday  \n",
       "3        Friday  \n",
       "4        Friday  \n",
       "...         ...  \n",
       "23669  Saturday  \n",
       "23670  Saturday  \n",
       "23671  Saturday  \n",
       "23672  Saturday  \n",
       "23673  Saturday  \n",
       "\n",
       "[23674 rows x 8 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timestamp('2017-07-01 11:00:00')"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Date'].min()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timestamp('2020-03-13 20:00:00')"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Date'].max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timedelta('986 days 09:00:00')"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Date'].max() - df['Date'].min()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>DayOfWeek</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>2020-03-13 20:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.94</td>\n",
       "      <td>131.82</td>\n",
       "      <td>126.87</td>\n",
       "      <td>128.71</td>\n",
       "      <td>1940673.93</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>2020-03-13 19:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>119.51</td>\n",
       "      <td>132.02</td>\n",
       "      <td>117.10</td>\n",
       "      <td>129.94</td>\n",
       "      <td>7579741.09</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2020-03-13 18:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.47</td>\n",
       "      <td>124.85</td>\n",
       "      <td>115.50</td>\n",
       "      <td>119.51</td>\n",
       "      <td>4898735.81</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>2020-03-13 17:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.08</td>\n",
       "      <td>127.42</td>\n",
       "      <td>121.63</td>\n",
       "      <td>124.47</td>\n",
       "      <td>2753450.92</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>2020-03-13 16:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.85</td>\n",
       "      <td>129.51</td>\n",
       "      <td>120.17</td>\n",
       "      <td>124.08</td>\n",
       "      <td>4461424.71</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1744</td>\n",
       "      <td>2020-01-01 04:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.57</td>\n",
       "      <td>130.00</td>\n",
       "      <td>129.50</td>\n",
       "      <td>129.56</td>\n",
       "      <td>702786.82</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1745</td>\n",
       "      <td>2020-01-01 03:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.37</td>\n",
       "      <td>130.44</td>\n",
       "      <td>129.38</td>\n",
       "      <td>129.57</td>\n",
       "      <td>496704.23</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1746</td>\n",
       "      <td>2020-01-01 02:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.14</td>\n",
       "      <td>130.50</td>\n",
       "      <td>129.91</td>\n",
       "      <td>130.37</td>\n",
       "      <td>396315.72</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1747</td>\n",
       "      <td>2020-01-01 01:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.34</td>\n",
       "      <td>130.14</td>\n",
       "      <td>128.32</td>\n",
       "      <td>130.14</td>\n",
       "      <td>635419.40</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1748</td>\n",
       "      <td>2020-01-01 00:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.54</td>\n",
       "      <td>128.54</td>\n",
       "      <td>128.12</td>\n",
       "      <td>128.34</td>\n",
       "      <td>245119.91</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1749 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Date  Symbol    Open    High     Low   Close      Volume  \\\n",
       "0    2020-03-13 20:00:00  ETHUSD  129.94  131.82  126.87  128.71  1940673.93   \n",
       "1    2020-03-13 19:00:00  ETHUSD  119.51  132.02  117.10  129.94  7579741.09   \n",
       "2    2020-03-13 18:00:00  ETHUSD  124.47  124.85  115.50  119.51  4898735.81   \n",
       "3    2020-03-13 17:00:00  ETHUSD  124.08  127.42  121.63  124.47  2753450.92   \n",
       "4    2020-03-13 16:00:00  ETHUSD  124.85  129.51  120.17  124.08  4461424.71   \n",
       "...                  ...     ...     ...     ...     ...     ...         ...   \n",
       "1744 2020-01-01 04:00:00  ETHUSD  129.57  130.00  129.50  129.56   702786.82   \n",
       "1745 2020-01-01 03:00:00  ETHUSD  130.37  130.44  129.38  129.57   496704.23   \n",
       "1746 2020-01-01 02:00:00  ETHUSD  130.14  130.50  129.91  130.37   396315.72   \n",
       "1747 2020-01-01 01:00:00  ETHUSD  128.34  130.14  128.32  130.14   635419.40   \n",
       "1748 2020-01-01 00:00:00  ETHUSD  128.54  128.54  128.12  128.34   245119.91   \n",
       "\n",
       "      DayOfWeek  \n",
       "0        Friday  \n",
       "1        Friday  \n",
       "2        Friday  \n",
       "3        Friday  \n",
       "4        Friday  \n",
       "...         ...  \n",
       "1744  Wednesday  \n",
       "1745  Wednesday  \n",
       "1746  Wednesday  \n",
       "1747  Wednesday  \n",
       "1748  Wednesday  \n",
       "\n",
       "[1749 rows x 8 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filt = (df['Date'] >= '2020')\n",
    "df.loc[filt]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>DayOfWeek</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>1749</td>\n",
       "      <td>2019-12-31 23:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.33</td>\n",
       "      <td>128.69</td>\n",
       "      <td>128.14</td>\n",
       "      <td>128.54</td>\n",
       "      <td>440678.91</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1750</td>\n",
       "      <td>2019-12-31 22:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.38</td>\n",
       "      <td>128.69</td>\n",
       "      <td>127.95</td>\n",
       "      <td>128.33</td>\n",
       "      <td>554646.02</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1751</td>\n",
       "      <td>2019-12-31 21:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>127.86</td>\n",
       "      <td>128.43</td>\n",
       "      <td>127.72</td>\n",
       "      <td>128.38</td>\n",
       "      <td>350155.69</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1752</td>\n",
       "      <td>2019-12-31 20:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>127.84</td>\n",
       "      <td>128.34</td>\n",
       "      <td>127.71</td>\n",
       "      <td>127.86</td>\n",
       "      <td>428183.38</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1753</td>\n",
       "      <td>2019-12-31 19:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.69</td>\n",
       "      <td>128.69</td>\n",
       "      <td>127.60</td>\n",
       "      <td>127.84</td>\n",
       "      <td>1169847.84</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10504</td>\n",
       "      <td>2019-01-01 04:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.75</td>\n",
       "      <td>133.96</td>\n",
       "      <td>130.74</td>\n",
       "      <td>131.96</td>\n",
       "      <td>2791135.37</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10505</td>\n",
       "      <td>2019-01-01 03:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.06</td>\n",
       "      <td>130.79</td>\n",
       "      <td>130.06</td>\n",
       "      <td>130.75</td>\n",
       "      <td>503732.63</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10506</td>\n",
       "      <td>2019-01-01 02:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.79</td>\n",
       "      <td>130.88</td>\n",
       "      <td>129.55</td>\n",
       "      <td>130.06</td>\n",
       "      <td>838183.43</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10507</td>\n",
       "      <td>2019-01-01 01:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>131.62</td>\n",
       "      <td>131.62</td>\n",
       "      <td>130.77</td>\n",
       "      <td>130.79</td>\n",
       "      <td>434917.99</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10508</td>\n",
       "      <td>2019-01-01 00:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.53</td>\n",
       "      <td>131.91</td>\n",
       "      <td>130.48</td>\n",
       "      <td>131.62</td>\n",
       "      <td>1067136.21</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8760 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Date  Symbol    Open    High     Low   Close      Volume  \\\n",
       "1749  2019-12-31 23:00:00  ETHUSD  128.33  128.69  128.14  128.54   440678.91   \n",
       "1750  2019-12-31 22:00:00  ETHUSD  128.38  128.69  127.95  128.33   554646.02   \n",
       "1751  2019-12-31 21:00:00  ETHUSD  127.86  128.43  127.72  128.38   350155.69   \n",
       "1752  2019-12-31 20:00:00  ETHUSD  127.84  128.34  127.71  127.86   428183.38   \n",
       "1753  2019-12-31 19:00:00  ETHUSD  128.69  128.69  127.60  127.84  1169847.84   \n",
       "...                   ...     ...     ...     ...     ...     ...         ...   \n",
       "10504 2019-01-01 04:00:00  ETHUSD  130.75  133.96  130.74  131.96  2791135.37   \n",
       "10505 2019-01-01 03:00:00  ETHUSD  130.06  130.79  130.06  130.75   503732.63   \n",
       "10506 2019-01-01 02:00:00  ETHUSD  130.79  130.88  129.55  130.06   838183.43   \n",
       "10507 2019-01-01 01:00:00  ETHUSD  131.62  131.62  130.77  130.79   434917.99   \n",
       "10508 2019-01-01 00:00:00  ETHUSD  130.53  131.91  130.48  131.62  1067136.21   \n",
       "\n",
       "      DayOfWeek  \n",
       "1749    Tuesday  \n",
       "1750    Tuesday  \n",
       "1751    Tuesday  \n",
       "1752    Tuesday  \n",
       "1753    Tuesday  \n",
       "...         ...  \n",
       "10504   Tuesday  \n",
       "10505   Tuesday  \n",
       "10506   Tuesday  \n",
       "10507   Tuesday  \n",
       "10508   Tuesday  \n",
       "\n",
       "[8760 rows x 8 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filt = (df['Date'] >= '2019') & (df['Date'] < '2020')\n",
    "df.loc[filt]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>DayOfWeek</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>1749</td>\n",
       "      <td>2019-12-31 23:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.33</td>\n",
       "      <td>128.69</td>\n",
       "      <td>128.14</td>\n",
       "      <td>128.54</td>\n",
       "      <td>440678.91</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1750</td>\n",
       "      <td>2019-12-31 22:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.38</td>\n",
       "      <td>128.69</td>\n",
       "      <td>127.95</td>\n",
       "      <td>128.33</td>\n",
       "      <td>554646.02</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1751</td>\n",
       "      <td>2019-12-31 21:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>127.86</td>\n",
       "      <td>128.43</td>\n",
       "      <td>127.72</td>\n",
       "      <td>128.38</td>\n",
       "      <td>350155.69</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1752</td>\n",
       "      <td>2019-12-31 20:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>127.84</td>\n",
       "      <td>128.34</td>\n",
       "      <td>127.71</td>\n",
       "      <td>127.86</td>\n",
       "      <td>428183.38</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1753</td>\n",
       "      <td>2019-12-31 19:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.69</td>\n",
       "      <td>128.69</td>\n",
       "      <td>127.60</td>\n",
       "      <td>127.84</td>\n",
       "      <td>1169847.84</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10504</td>\n",
       "      <td>2019-01-01 04:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.75</td>\n",
       "      <td>133.96</td>\n",
       "      <td>130.74</td>\n",
       "      <td>131.96</td>\n",
       "      <td>2791135.37</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10505</td>\n",
       "      <td>2019-01-01 03:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.06</td>\n",
       "      <td>130.79</td>\n",
       "      <td>130.06</td>\n",
       "      <td>130.75</td>\n",
       "      <td>503732.63</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10506</td>\n",
       "      <td>2019-01-01 02:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.79</td>\n",
       "      <td>130.88</td>\n",
       "      <td>129.55</td>\n",
       "      <td>130.06</td>\n",
       "      <td>838183.43</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10507</td>\n",
       "      <td>2019-01-01 01:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>131.62</td>\n",
       "      <td>131.62</td>\n",
       "      <td>130.77</td>\n",
       "      <td>130.79</td>\n",
       "      <td>434917.99</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10508</td>\n",
       "      <td>2019-01-01 00:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.53</td>\n",
       "      <td>131.91</td>\n",
       "      <td>130.48</td>\n",
       "      <td>131.62</td>\n",
       "      <td>1067136.21</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8760 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Date  Symbol    Open    High     Low   Close      Volume  \\\n",
       "1749  2019-12-31 23:00:00  ETHUSD  128.33  128.69  128.14  128.54   440678.91   \n",
       "1750  2019-12-31 22:00:00  ETHUSD  128.38  128.69  127.95  128.33   554646.02   \n",
       "1751  2019-12-31 21:00:00  ETHUSD  127.86  128.43  127.72  128.38   350155.69   \n",
       "1752  2019-12-31 20:00:00  ETHUSD  127.84  128.34  127.71  127.86   428183.38   \n",
       "1753  2019-12-31 19:00:00  ETHUSD  128.69  128.69  127.60  127.84  1169847.84   \n",
       "...                   ...     ...     ...     ...     ...     ...         ...   \n",
       "10504 2019-01-01 04:00:00  ETHUSD  130.75  133.96  130.74  131.96  2791135.37   \n",
       "10505 2019-01-01 03:00:00  ETHUSD  130.06  130.79  130.06  130.75   503732.63   \n",
       "10506 2019-01-01 02:00:00  ETHUSD  130.79  130.88  129.55  130.06   838183.43   \n",
       "10507 2019-01-01 01:00:00  ETHUSD  131.62  131.62  130.77  130.79   434917.99   \n",
       "10508 2019-01-01 00:00:00  ETHUSD  130.53  131.91  130.48  131.62  1067136.21   \n",
       "\n",
       "      DayOfWeek  \n",
       "1749    Tuesday  \n",
       "1750    Tuesday  \n",
       "1751    Tuesday  \n",
       "1752    Tuesday  \n",
       "1753    Tuesday  \n",
       "...         ...  \n",
       "10504   Tuesday  \n",
       "10505   Tuesday  \n",
       "10506   Tuesday  \n",
       "10507   Tuesday  \n",
       "10508   Tuesday  \n",
       "\n",
       "[8760 rows x 8 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filt = (df['Date'] >= pd.to_datetime('2019-01-01')) & (df['Date'] < pd.to_datetime('2020-01-01'))\n",
    "df.loc[filt]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>DayOfWeek</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2020-03-13 20:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.94</td>\n",
       "      <td>131.82</td>\n",
       "      <td>126.87</td>\n",
       "      <td>128.71</td>\n",
       "      <td>1940673.93</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-03-13 19:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>119.51</td>\n",
       "      <td>132.02</td>\n",
       "      <td>117.10</td>\n",
       "      <td>129.94</td>\n",
       "      <td>7579741.09</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-03-13 18:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.47</td>\n",
       "      <td>124.85</td>\n",
       "      <td>115.50</td>\n",
       "      <td>119.51</td>\n",
       "      <td>4898735.81</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-03-13 17:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.08</td>\n",
       "      <td>127.42</td>\n",
       "      <td>121.63</td>\n",
       "      <td>124.47</td>\n",
       "      <td>2753450.92</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-03-13 16:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.85</td>\n",
       "      <td>129.51</td>\n",
       "      <td>120.17</td>\n",
       "      <td>124.08</td>\n",
       "      <td>4461424.71</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2017-07-01 15:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>265.74</td>\n",
       "      <td>272.74</td>\n",
       "      <td>265.00</td>\n",
       "      <td>272.57</td>\n",
       "      <td>1500282.55</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2017-07-01 14:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>268.79</td>\n",
       "      <td>269.90</td>\n",
       "      <td>265.00</td>\n",
       "      <td>265.74</td>\n",
       "      <td>1702536.85</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2017-07-01 13:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>274.83</td>\n",
       "      <td>274.93</td>\n",
       "      <td>265.00</td>\n",
       "      <td>268.79</td>\n",
       "      <td>3010787.99</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2017-07-01 12:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>275.01</td>\n",
       "      <td>275.01</td>\n",
       "      <td>271.00</td>\n",
       "      <td>274.83</td>\n",
       "      <td>824362.87</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2017-07-01 11:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>279.98</td>\n",
       "      <td>279.99</td>\n",
       "      <td>272.10</td>\n",
       "      <td>275.01</td>\n",
       "      <td>679358.87</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23674 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Symbol    Open    High     Low   Close      Volume  \\\n",
       "Date                                                                      \n",
       "2020-03-13 20:00:00  ETHUSD  129.94  131.82  126.87  128.71  1940673.93   \n",
       "2020-03-13 19:00:00  ETHUSD  119.51  132.02  117.10  129.94  7579741.09   \n",
       "2020-03-13 18:00:00  ETHUSD  124.47  124.85  115.50  119.51  4898735.81   \n",
       "2020-03-13 17:00:00  ETHUSD  124.08  127.42  121.63  124.47  2753450.92   \n",
       "2020-03-13 16:00:00  ETHUSD  124.85  129.51  120.17  124.08  4461424.71   \n",
       "...                     ...     ...     ...     ...     ...         ...   \n",
       "2017-07-01 15:00:00  ETHUSD  265.74  272.74  265.00  272.57  1500282.55   \n",
       "2017-07-01 14:00:00  ETHUSD  268.79  269.90  265.00  265.74  1702536.85   \n",
       "2017-07-01 13:00:00  ETHUSD  274.83  274.93  265.00  268.79  3010787.99   \n",
       "2017-07-01 12:00:00  ETHUSD  275.01  275.01  271.00  274.83   824362.87   \n",
       "2017-07-01 11:00:00  ETHUSD  279.98  279.99  272.10  275.01   679358.87   \n",
       "\n",
       "                    DayOfWeek  \n",
       "Date                           \n",
       "2020-03-13 20:00:00    Friday  \n",
       "2020-03-13 19:00:00    Friday  \n",
       "2020-03-13 18:00:00    Friday  \n",
       "2020-03-13 17:00:00    Friday  \n",
       "2020-03-13 16:00:00    Friday  \n",
       "...                       ...  \n",
       "2017-07-01 15:00:00  Saturday  \n",
       "2017-07-01 14:00:00  Saturday  \n",
       "2017-07-01 13:00:00  Saturday  \n",
       "2017-07-01 12:00:00  Saturday  \n",
       "2017-07-01 11:00:00  Saturday  \n",
       "\n",
       "[23674 rows x 7 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.set_index('Date')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.set_index('Date',inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>DayOfWeek</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2020-03-13 20:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.94</td>\n",
       "      <td>131.82</td>\n",
       "      <td>126.87</td>\n",
       "      <td>128.71</td>\n",
       "      <td>1940673.93</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-03-13 19:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>119.51</td>\n",
       "      <td>132.02</td>\n",
       "      <td>117.10</td>\n",
       "      <td>129.94</td>\n",
       "      <td>7579741.09</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-03-13 18:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.47</td>\n",
       "      <td>124.85</td>\n",
       "      <td>115.50</td>\n",
       "      <td>119.51</td>\n",
       "      <td>4898735.81</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-03-13 17:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.08</td>\n",
       "      <td>127.42</td>\n",
       "      <td>121.63</td>\n",
       "      <td>124.47</td>\n",
       "      <td>2753450.92</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-03-13 16:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>124.85</td>\n",
       "      <td>129.51</td>\n",
       "      <td>120.17</td>\n",
       "      <td>124.08</td>\n",
       "      <td>4461424.71</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2017-07-01 15:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>265.74</td>\n",
       "      <td>272.74</td>\n",
       "      <td>265.00</td>\n",
       "      <td>272.57</td>\n",
       "      <td>1500282.55</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2017-07-01 14:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>268.79</td>\n",
       "      <td>269.90</td>\n",
       "      <td>265.00</td>\n",
       "      <td>265.74</td>\n",
       "      <td>1702536.85</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2017-07-01 13:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>274.83</td>\n",
       "      <td>274.93</td>\n",
       "      <td>265.00</td>\n",
       "      <td>268.79</td>\n",
       "      <td>3010787.99</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2017-07-01 12:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>275.01</td>\n",
       "      <td>275.01</td>\n",
       "      <td>271.00</td>\n",
       "      <td>274.83</td>\n",
       "      <td>824362.87</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2017-07-01 11:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>279.98</td>\n",
       "      <td>279.99</td>\n",
       "      <td>272.10</td>\n",
       "      <td>275.01</td>\n",
       "      <td>679358.87</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23674 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Symbol    Open    High     Low   Close      Volume  \\\n",
       "Date                                                                      \n",
       "2020-03-13 20:00:00  ETHUSD  129.94  131.82  126.87  128.71  1940673.93   \n",
       "2020-03-13 19:00:00  ETHUSD  119.51  132.02  117.10  129.94  7579741.09   \n",
       "2020-03-13 18:00:00  ETHUSD  124.47  124.85  115.50  119.51  4898735.81   \n",
       "2020-03-13 17:00:00  ETHUSD  124.08  127.42  121.63  124.47  2753450.92   \n",
       "2020-03-13 16:00:00  ETHUSD  124.85  129.51  120.17  124.08  4461424.71   \n",
       "...                     ...     ...     ...     ...     ...         ...   \n",
       "2017-07-01 15:00:00  ETHUSD  265.74  272.74  265.00  272.57  1500282.55   \n",
       "2017-07-01 14:00:00  ETHUSD  268.79  269.90  265.00  265.74  1702536.85   \n",
       "2017-07-01 13:00:00  ETHUSD  274.83  274.93  265.00  268.79  3010787.99   \n",
       "2017-07-01 12:00:00  ETHUSD  275.01  275.01  271.00  274.83   824362.87   \n",
       "2017-07-01 11:00:00  ETHUSD  279.98  279.99  272.10  275.01   679358.87   \n",
       "\n",
       "                    DayOfWeek  \n",
       "Date                           \n",
       "2020-03-13 20:00:00    Friday  \n",
       "2020-03-13 19:00:00    Friday  \n",
       "2020-03-13 18:00:00    Friday  \n",
       "2020-03-13 17:00:00    Friday  \n",
       "2020-03-13 16:00:00    Friday  \n",
       "...                       ...  \n",
       "2017-07-01 15:00:00  Saturday  \n",
       "2017-07-01 14:00:00  Saturday  \n",
       "2017-07-01 13:00:00  Saturday  \n",
       "2017-07-01 12:00:00  Saturday  \n",
       "2017-07-01 11:00:00  Saturday  \n",
       "\n",
       "[23674 rows x 7 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>DayOfWeek</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2019-12-31 23:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.33</td>\n",
       "      <td>128.69</td>\n",
       "      <td>128.14</td>\n",
       "      <td>128.54</td>\n",
       "      <td>440678.91</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2019-12-31 22:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.38</td>\n",
       "      <td>128.69</td>\n",
       "      <td>127.95</td>\n",
       "      <td>128.33</td>\n",
       "      <td>554646.02</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2019-12-31 21:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>127.86</td>\n",
       "      <td>128.43</td>\n",
       "      <td>127.72</td>\n",
       "      <td>128.38</td>\n",
       "      <td>350155.69</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2019-12-31 20:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>127.84</td>\n",
       "      <td>128.34</td>\n",
       "      <td>127.71</td>\n",
       "      <td>127.86</td>\n",
       "      <td>428183.38</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2019-12-31 19:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.69</td>\n",
       "      <td>128.69</td>\n",
       "      <td>127.60</td>\n",
       "      <td>127.84</td>\n",
       "      <td>1169847.84</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2019-01-01 04:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.75</td>\n",
       "      <td>133.96</td>\n",
       "      <td>130.74</td>\n",
       "      <td>131.96</td>\n",
       "      <td>2791135.37</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2019-01-01 03:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.06</td>\n",
       "      <td>130.79</td>\n",
       "      <td>130.06</td>\n",
       "      <td>130.75</td>\n",
       "      <td>503732.63</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2019-01-01 02:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.79</td>\n",
       "      <td>130.88</td>\n",
       "      <td>129.55</td>\n",
       "      <td>130.06</td>\n",
       "      <td>838183.43</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2019-01-01 01:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>131.62</td>\n",
       "      <td>131.62</td>\n",
       "      <td>130.77</td>\n",
       "      <td>130.79</td>\n",
       "      <td>434917.99</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2019-01-01 00:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.53</td>\n",
       "      <td>131.91</td>\n",
       "      <td>130.48</td>\n",
       "      <td>131.62</td>\n",
       "      <td>1067136.21</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8760 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Symbol    Open    High     Low   Close      Volume  \\\n",
       "Date                                                                      \n",
       "2019-12-31 23:00:00  ETHUSD  128.33  128.69  128.14  128.54   440678.91   \n",
       "2019-12-31 22:00:00  ETHUSD  128.38  128.69  127.95  128.33   554646.02   \n",
       "2019-12-31 21:00:00  ETHUSD  127.86  128.43  127.72  128.38   350155.69   \n",
       "2019-12-31 20:00:00  ETHUSD  127.84  128.34  127.71  127.86   428183.38   \n",
       "2019-12-31 19:00:00  ETHUSD  128.69  128.69  127.60  127.84  1169847.84   \n",
       "...                     ...     ...     ...     ...     ...         ...   \n",
       "2019-01-01 04:00:00  ETHUSD  130.75  133.96  130.74  131.96  2791135.37   \n",
       "2019-01-01 03:00:00  ETHUSD  130.06  130.79  130.06  130.75   503732.63   \n",
       "2019-01-01 02:00:00  ETHUSD  130.79  130.88  129.55  130.06   838183.43   \n",
       "2019-01-01 01:00:00  ETHUSD  131.62  131.62  130.77  130.79   434917.99   \n",
       "2019-01-01 00:00:00  ETHUSD  130.53  131.91  130.48  131.62  1067136.21   \n",
       "\n",
       "                    DayOfWeek  \n",
       "Date                           \n",
       "2019-12-31 23:00:00   Tuesday  \n",
       "2019-12-31 22:00:00   Tuesday  \n",
       "2019-12-31 21:00:00   Tuesday  \n",
       "2019-12-31 20:00:00   Tuesday  \n",
       "2019-12-31 19:00:00   Tuesday  \n",
       "...                       ...  \n",
       "2019-01-01 04:00:00   Tuesday  \n",
       "2019-01-01 03:00:00   Tuesday  \n",
       "2019-01-01 02:00:00   Tuesday  \n",
       "2019-01-01 01:00:00   Tuesday  \n",
       "2019-01-01 00:00:00   Tuesday  \n",
       "\n",
       "[8760 rows x 7 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['2019']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>DayOfWeek</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2020-02-29 23:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>223.35</td>\n",
       "      <td>223.58</td>\n",
       "      <td>216.83</td>\n",
       "      <td>217.31</td>\n",
       "      <td>1927939.88</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 22:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>223.48</td>\n",
       "      <td>223.59</td>\n",
       "      <td>222.14</td>\n",
       "      <td>223.35</td>\n",
       "      <td>535998.57</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 21:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>224.63</td>\n",
       "      <td>225.14</td>\n",
       "      <td>222.74</td>\n",
       "      <td>223.48</td>\n",
       "      <td>561158.03</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 20:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>225.31</td>\n",
       "      <td>225.33</td>\n",
       "      <td>223.50</td>\n",
       "      <td>224.63</td>\n",
       "      <td>511648.65</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 19:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>225.09</td>\n",
       "      <td>225.85</td>\n",
       "      <td>223.87</td>\n",
       "      <td>225.31</td>\n",
       "      <td>1250856.20</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-01-01 04:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>129.57</td>\n",
       "      <td>130.00</td>\n",
       "      <td>129.50</td>\n",
       "      <td>129.56</td>\n",
       "      <td>702786.82</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-01-01 03:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.37</td>\n",
       "      <td>130.44</td>\n",
       "      <td>129.38</td>\n",
       "      <td>129.57</td>\n",
       "      <td>496704.23</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-01-01 02:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>130.14</td>\n",
       "      <td>130.50</td>\n",
       "      <td>129.91</td>\n",
       "      <td>130.37</td>\n",
       "      <td>396315.72</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-01-01 01:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.34</td>\n",
       "      <td>130.14</td>\n",
       "      <td>128.32</td>\n",
       "      <td>130.14</td>\n",
       "      <td>635419.40</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-01-01 00:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>128.54</td>\n",
       "      <td>128.54</td>\n",
       "      <td>128.12</td>\n",
       "      <td>128.34</td>\n",
       "      <td>245119.91</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1440 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Symbol    Open    High     Low   Close      Volume  \\\n",
       "Date                                                                      \n",
       "2020-02-29 23:00:00  ETHUSD  223.35  223.58  216.83  217.31  1927939.88   \n",
       "2020-02-29 22:00:00  ETHUSD  223.48  223.59  222.14  223.35   535998.57   \n",
       "2020-02-29 21:00:00  ETHUSD  224.63  225.14  222.74  223.48   561158.03   \n",
       "2020-02-29 20:00:00  ETHUSD  225.31  225.33  223.50  224.63   511648.65   \n",
       "2020-02-29 19:00:00  ETHUSD  225.09  225.85  223.87  225.31  1250856.20   \n",
       "...                     ...     ...     ...     ...     ...         ...   \n",
       "2020-01-01 04:00:00  ETHUSD  129.57  130.00  129.50  129.56   702786.82   \n",
       "2020-01-01 03:00:00  ETHUSD  130.37  130.44  129.38  129.57   496704.23   \n",
       "2020-01-01 02:00:00  ETHUSD  130.14  130.50  129.91  130.37   396315.72   \n",
       "2020-01-01 01:00:00  ETHUSD  128.34  130.14  128.32  130.14   635419.40   \n",
       "2020-01-01 00:00:00  ETHUSD  128.54  128.54  128.12  128.34   245119.91   \n",
       "\n",
       "                     DayOfWeek  \n",
       "Date                            \n",
       "2020-02-29 23:00:00   Saturday  \n",
       "2020-02-29 22:00:00   Saturday  \n",
       "2020-02-29 21:00:00   Saturday  \n",
       "2020-02-29 20:00:00   Saturday  \n",
       "2020-02-29 19:00:00   Saturday  \n",
       "...                        ...  \n",
       "2020-01-01 04:00:00  Wednesday  \n",
       "2020-01-01 03:00:00  Wednesday  \n",
       "2020-01-01 02:00:00  Wednesday  \n",
       "2020-01-01 01:00:00  Wednesday  \n",
       "2020-01-01 00:00:00  Wednesday  \n",
       "\n",
       "[1440 rows x 7 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['2020-01':'2020-02']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "195.16559027777814"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['2020-01':'2020-02']['Close'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Symbol</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>DayOfWeek</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2020-02-29 23:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>223.35</td>\n",
       "      <td>223.58</td>\n",
       "      <td>216.83</td>\n",
       "      <td>217.31</td>\n",
       "      <td>1927939.88</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 22:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>223.48</td>\n",
       "      <td>223.59</td>\n",
       "      <td>222.14</td>\n",
       "      <td>223.35</td>\n",
       "      <td>535998.57</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 21:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>224.63</td>\n",
       "      <td>225.14</td>\n",
       "      <td>222.74</td>\n",
       "      <td>223.48</td>\n",
       "      <td>561158.03</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 20:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>225.31</td>\n",
       "      <td>225.33</td>\n",
       "      <td>223.50</td>\n",
       "      <td>224.63</td>\n",
       "      <td>511648.65</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 19:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>225.09</td>\n",
       "      <td>225.85</td>\n",
       "      <td>223.87</td>\n",
       "      <td>225.31</td>\n",
       "      <td>1250856.20</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 18:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>225.53</td>\n",
       "      <td>226.17</td>\n",
       "      <td>224.50</td>\n",
       "      <td>225.09</td>\n",
       "      <td>496543.91</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 17:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>222.68</td>\n",
       "      <td>225.53</td>\n",
       "      <td>222.24</td>\n",
       "      <td>225.53</td>\n",
       "      <td>611136.47</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 16:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>224.17</td>\n",
       "      <td>225.93</td>\n",
       "      <td>222.36</td>\n",
       "      <td>222.68</td>\n",
       "      <td>694384.75</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 15:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>223.35</td>\n",
       "      <td>225.88</td>\n",
       "      <td>221.80</td>\n",
       "      <td>224.17</td>\n",
       "      <td>550893.74</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 14:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>224.42</td>\n",
       "      <td>224.42</td>\n",
       "      <td>221.15</td>\n",
       "      <td>223.35</td>\n",
       "      <td>1479928.44</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 13:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>225.29</td>\n",
       "      <td>225.37</td>\n",
       "      <td>222.87</td>\n",
       "      <td>224.42</td>\n",
       "      <td>1076646.41</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 12:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>226.50</td>\n",
       "      <td>226.50</td>\n",
       "      <td>224.14</td>\n",
       "      <td>225.29</td>\n",
       "      <td>359022.09</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 11:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>223.11</td>\n",
       "      <td>226.74</td>\n",
       "      <td>222.19</td>\n",
       "      <td>226.50</td>\n",
       "      <td>684186.89</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 10:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>225.86</td>\n",
       "      <td>228.11</td>\n",
       "      <td>222.77</td>\n",
       "      <td>223.11</td>\n",
       "      <td>1053817.02</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 09:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>228.78</td>\n",
       "      <td>228.78</td>\n",
       "      <td>225.10</td>\n",
       "      <td>225.86</td>\n",
       "      <td>880482.27</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 08:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>229.73</td>\n",
       "      <td>230.38</td>\n",
       "      <td>228.32</td>\n",
       "      <td>228.78</td>\n",
       "      <td>222951.78</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 07:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>228.67</td>\n",
       "      <td>230.06</td>\n",
       "      <td>227.84</td>\n",
       "      <td>229.73</td>\n",
       "      <td>603444.28</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 06:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>232.13</td>\n",
       "      <td>233.00</td>\n",
       "      <td>228.03</td>\n",
       "      <td>228.67</td>\n",
       "      <td>1573935.25</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 05:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>232.09</td>\n",
       "      <td>233.32</td>\n",
       "      <td>231.16</td>\n",
       "      <td>232.13</td>\n",
       "      <td>855793.43</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 04:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>230.41</td>\n",
       "      <td>233.00</td>\n",
       "      <td>230.32</td>\n",
       "      <td>232.09</td>\n",
       "      <td>754164.18</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 03:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>229.23</td>\n",
       "      <td>230.83</td>\n",
       "      <td>228.17</td>\n",
       "      <td>230.41</td>\n",
       "      <td>1173484.59</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 02:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>227.45</td>\n",
       "      <td>230.33</td>\n",
       "      <td>227.19</td>\n",
       "      <td>229.23</td>\n",
       "      <td>1120127.13</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 01:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>229.81</td>\n",
       "      <td>231.00</td>\n",
       "      <td>227.38</td>\n",
       "      <td>227.45</td>\n",
       "      <td>696316.26</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-29 00:00:00</td>\n",
       "      <td>ETHUSD</td>\n",
       "      <td>227.37</td>\n",
       "      <td>232.20</td>\n",
       "      <td>227.04</td>\n",
       "      <td>229.81</td>\n",
       "      <td>1435038.82</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     Symbol    Open    High     Low   Close      Volume  \\\n",
       "Date                                                                      \n",
       "2020-02-29 23:00:00  ETHUSD  223.35  223.58  216.83  217.31  1927939.88   \n",
       "2020-02-29 22:00:00  ETHUSD  223.48  223.59  222.14  223.35   535998.57   \n",
       "2020-02-29 21:00:00  ETHUSD  224.63  225.14  222.74  223.48   561158.03   \n",
       "2020-02-29 20:00:00  ETHUSD  225.31  225.33  223.50  224.63   511648.65   \n",
       "2020-02-29 19:00:00  ETHUSD  225.09  225.85  223.87  225.31  1250856.20   \n",
       "2020-02-29 18:00:00  ETHUSD  225.53  226.17  224.50  225.09   496543.91   \n",
       "2020-02-29 17:00:00  ETHUSD  222.68  225.53  222.24  225.53   611136.47   \n",
       "2020-02-29 16:00:00  ETHUSD  224.17  225.93  222.36  222.68   694384.75   \n",
       "2020-02-29 15:00:00  ETHUSD  223.35  225.88  221.80  224.17   550893.74   \n",
       "2020-02-29 14:00:00  ETHUSD  224.42  224.42  221.15  223.35  1479928.44   \n",
       "2020-02-29 13:00:00  ETHUSD  225.29  225.37  222.87  224.42  1076646.41   \n",
       "2020-02-29 12:00:00  ETHUSD  226.50  226.50  224.14  225.29   359022.09   \n",
       "2020-02-29 11:00:00  ETHUSD  223.11  226.74  222.19  226.50   684186.89   \n",
       "2020-02-29 10:00:00  ETHUSD  225.86  228.11  222.77  223.11  1053817.02   \n",
       "2020-02-29 09:00:00  ETHUSD  228.78  228.78  225.10  225.86   880482.27   \n",
       "2020-02-29 08:00:00  ETHUSD  229.73  230.38  228.32  228.78   222951.78   \n",
       "2020-02-29 07:00:00  ETHUSD  228.67  230.06  227.84  229.73   603444.28   \n",
       "2020-02-29 06:00:00  ETHUSD  232.13  233.00  228.03  228.67  1573935.25   \n",
       "2020-02-29 05:00:00  ETHUSD  232.09  233.32  231.16  232.13   855793.43   \n",
       "2020-02-29 04:00:00  ETHUSD  230.41  233.00  230.32  232.09   754164.18   \n",
       "2020-02-29 03:00:00  ETHUSD  229.23  230.83  228.17  230.41  1173484.59   \n",
       "2020-02-29 02:00:00  ETHUSD  227.45  230.33  227.19  229.23  1120127.13   \n",
       "2020-02-29 01:00:00  ETHUSD  229.81  231.00  227.38  227.45   696316.26   \n",
       "2020-02-29 00:00:00  ETHUSD  227.37  232.20  227.04  229.81  1435038.82   \n",
       "\n",
       "                    DayOfWeek  \n",
       "Date                           \n",
       "2020-02-29 23:00:00  Saturday  \n",
       "2020-02-29 22:00:00  Saturday  \n",
       "2020-02-29 21:00:00  Saturday  \n",
       "2020-02-29 20:00:00  Saturday  \n",
       "2020-02-29 19:00:00  Saturday  \n",
       "2020-02-29 18:00:00  Saturday  \n",
       "2020-02-29 17:00:00  Saturday  \n",
       "2020-02-29 16:00:00  Saturday  \n",
       "2020-02-29 15:00:00  Saturday  \n",
       "2020-02-29 14:00:00  Saturday  \n",
       "2020-02-29 13:00:00  Saturday  \n",
       "2020-02-29 12:00:00  Saturday  \n",
       "2020-02-29 11:00:00  Saturday  \n",
       "2020-02-29 10:00:00  Saturday  \n",
       "2020-02-29 09:00:00  Saturday  \n",
       "2020-02-29 08:00:00  Saturday  \n",
       "2020-02-29 07:00:00  Saturday  \n",
       "2020-02-29 06:00:00  Saturday  \n",
       "2020-02-29 05:00:00  Saturday  \n",
       "2020-02-29 04:00:00  Saturday  \n",
       "2020-02-29 03:00:00  Saturday  \n",
       "2020-02-29 02:00:00  Saturday  \n",
       "2020-02-29 01:00:00  Saturday  \n",
       "2020-02-29 00:00:00  Saturday  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['2020-01':'2020-02'].head(24)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date\n",
       "2020-01-01 23:00:00    130.27\n",
       "2020-01-01 22:00:00    131.41\n",
       "2020-01-01 21:00:00    131.99\n",
       "2020-01-01 20:00:00    131.87\n",
       "2020-01-01 19:00:00    131.72\n",
       "2020-01-01 18:00:00    132.14\n",
       "2020-01-01 17:00:00    132.68\n",
       "2020-01-01 16:00:00    132.56\n",
       "2020-01-01 15:00:00    132.15\n",
       "2020-01-01 14:00:00    132.05\n",
       "2020-01-01 13:00:00    132.08\n",
       "2020-01-01 12:00:00    131.31\n",
       "2020-01-01 11:00:00    131.42\n",
       "2020-01-01 10:00:00    130.33\n",
       "2020-01-01 09:00:00    130.22\n",
       "2020-01-01 08:00:00    130.01\n",
       "2020-01-01 07:00:00    130.25\n",
       "2020-01-01 06:00:00    130.25\n",
       "2020-01-01 05:00:00    129.94\n",
       "2020-01-01 04:00:00    130.00\n",
       "2020-01-01 03:00:00    130.44\n",
       "2020-01-01 02:00:00    130.50\n",
       "2020-01-01 01:00:00    130.14\n",
       "2020-01-01 00:00:00    128.54\n",
       "Name: High, dtype: float64"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['2020-01-01']['High']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "132.68"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['2020-01-01']['High'].max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date\n",
       "2017-07-01    279.99\n",
       "2017-07-02    293.73\n",
       "2017-07-03    285.00\n",
       "2017-07-04    282.83\n",
       "2017-07-05    274.97\n",
       "               ...  \n",
       "2020-03-09    208.65\n",
       "2020-03-10    206.28\n",
       "2020-03-11    202.98\n",
       "2020-03-12    195.64\n",
       "2020-03-13    148.00\n",
       "Freq: D, Name: High, Length: 987, dtype: float64"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['High'].resample('D').max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "132.68"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "highs = df['High'].resample('D').max()\n",
    "highs['2020-01-01']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x2146b83a4c8>"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX0AAAESCAYAAAAR2wXeAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjEsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy8QZhcZAAAgAElEQVR4nO3dd5xU1fn48c+zO9sryy7LwtKbUgURW0QMilgimsTE8lO/xsQkajQaTYwpxqjRfE1iYs3XXmJvERVFLFhAEJAiVZZelrJs71PO7497Z3a2z+zM7swyz/v14sXMvXfunOGyz5x97jnPEWMMSimlYkNcpBuglFKq52jQV0qpGKJBXymlYogGfaWUiiEa9JVSKoZo0FdKqRjiiHQDOpKbm2uGDh0a6WYopVSvsmLFihJjTF5b+6I66A8dOpTly5dHuhlKKdWriMiO9vZpekcppWKIBn2llIohGvSVUiqGaNBXSqkYokFfKaViiAZ9pZSKIRr0ewFjDB6PlsBWSoWu06AvIk+IyAERWdvGvhtFxIhIrv1cROQ+ESkSkTUiMsXv2MtEZLP957LwfozD28n3LOT4uz+MdDOUUoeBQHr6TwGzW24UkUHAacBOv81nAKPsP1cCD9vH5gC3AscC04BbRaRPKA2PJTtLa9lf2RDpZiilDgOdBn1jzKdAaRu77gV+DfjnHeYAzxjLEiBbRAqA04EFxphSY0wZsIA2vkiUUkp1ry7l9EXkHGCPMWZ1i10DgV1+z3fb29rbroKgS1sqpUIVdO0dEUkFfgfMamt3G9tMB9vbOv+VWKkhBg8eHGzzDjuV9U7f4zqnm9TEqC6XpJSKcl3p6Y8AhgGrRWQ7UAh8JSL9sXrwg/yOLQT2drC9FWPMI8aYqcaYqXl5bRaJiykT//S+73HRgeoItkQpdTgIOugbY742xvQzxgw1xgzFCuhTjDH7gLnApfYonuOACmNMMTAfmCUifewbuLPsbSoIK3eWR7oJSqleLpAhmy8AXwBjRGS3iFzRweHzgK1AEfAocBWAMaYUuB1YZv/5s71NBaHe6Y50E5RSvVynCWJjzIWd7B/q99gAV7dz3BPAE0G2T/lxuj2RboJSqpfTGbm9SKNbR+8opUKjQb8X0Z6+UipUGvR7kUaXBn2lVGg06Pci2tNXSoVKg34UazkDV4O+UipUGvSjWEOLdE7L50opFSwN+lGssUXP3qmjd5RSIdKgH8UanC2Cvvb0lVIh0qAfxVr29Fs+V0qpYGnQj2INLcou6I1cpVSoNOhHsVY9fU3vKKVCpEE/irUM8trTV0qFSoN+FPMO0fzVaaM5cWRfzekrpUKmQT+KeXv604blkJ7kwOnSIZtKqdBo0I9iDS7rRm5SQjyJjnhN7yilQqZBP4p5e/qJ8XEkxIvOyFVKhUyDfhTzBvmkhDgS4+O0p6+UCpkG/SjW4NfTT3Ro0FdKhU6DfhRr9OvpJ8THae0dpVTINOhHMV96Jz6ehPi4ZuP2PR6jk7WUUkHToB/FvOmcBIeQGC80uj2+Gvt3vLOB0b9/l+oGVySbqJTqZToN+iLyhIgcEJG1ftvuEZGNIrJGRN4QkWy/fb8VkSIR2SQip/ttn21vKxKRm8P/UQ4/Lm/Qt3P6AC6PFfSfWrwNgC0HqiPTOKVUrxRIT/8pYHaLbQuA8caYicA3wG8BRGQscAEwzn7NQyISLyLxwIPAGcBY4EL7WNWBRjuH74gTEuKtS+VN6aQlOgCoadSevlIqcJ0GfWPMp0Bpi23vG2O80WYJUGg/ngO8aIxpMMZsA4qAafafImPMVmNMI/CifazqgMvtwREniDQF/aaUj/W8rtHd7uuVUqqlcOT0fwS8az8eCOzy27fb3tbe9lZE5EoRWS4iyw8ePBiG5vVeLo/xBXtvkG/0pXwEgBoN+kqpIIQU9EXkd4ALeM67qY3DTAfbW2805hFjzFRjzNS8vLxQmtfrNbo8OOzgntQiveP9MqjVG7lKqSA4uvpCEbkMOBuYabxDSqwe/CC/wwqBvfbj9rardrg8Hr+evhX8vWP1E+3t2tNXSgWjSz19EZkN/AY4xxhT67drLnCBiCSJyDBgFPAlsAwYJSLDRCQR62bv3NCafvhzuowvjdMyp+/9DaBOb+QqpYIQyJDNF4AvgDEisltErgAeADKABSKySkT+DWCMWQe8DKwH3gOuNsa47Zu+1wDzgQ3Ay/axqgNOjwdHnN3Tt4P+F1sONTtGe/pKqWB0mt4xxlzYxubHOzj+TuDONrbPA+YF1boY53I39fS94/RvnbuOiYVZuOw0j+b0lVLB0Bm5Uczpbsrpe3P4AF/vqfCN4qnVnr5SKgga9KOY021wxDdP7wDsq6j35fYr6pwRaZtSqnfSoB/FrNE7zdM7AG5jfOmd99fvZ9O+qoi0TynV+2jQj2L+6R1v8AcwhmaLpBdp/R2lVIA06Ecxp9vgiLN7+n7pnQan29fTB+iTmtDjbVNK9U4a9KOYq1lPv+lS1Ts9uoqWUqpLNOhHMWcbQzbBqqzp8hjSk6wRt06PrqillAqMBv0o5nR72hy9U1rTCMApR/QDwO3RXr9SKjAa9KOYVWWzdU5/sT0rNzvFyuXr2rlKqUBp0I9i/qN3MpJbT57OsoO+S4O+UipAGvSjmMttfLV34uKEv5w3odn+bHvUjkvTO0qpAGnQj2JOt4dER9P4/IuOHcyssfm+58kJ8fZx2tNXSgVGg34Uc7qbqmx6eQM9gNsetaM3cpVSgdKgH8VcbuOrm++V5Dd087jhfQHt6SulAqdBP4o5PZ5mo3agqad/1YwR5GUkAdYkLqWUCoQG/SjmbKOnb+ylhTOSE3z7XDo5SykVIA36UcoYg9tjWuX0nS4rwKcnO3x1eTS9o5QKlAb9KOVbAN3RIujbN22THXG+LwS9kauUCpQG/SjlWwA9Tlpsb/oy8M7W1Z6+UipQGvSjlHeWrSO+ZXrH+2UQh4gQHyc6OUspFbBOg76IPCEiB0Rkrd+2HBFZICKb7b/72NtFRO4TkSIRWSMiU/xec5l9/GYRuax7Ps7ho8FlrX2b2M6NXG/axxEn2tNXSgUskJ7+U8DsFttuBj40xowCPrSfA5wBjLL/XAk8DNaXBHArcCwwDbjV+0Wh2nb/R0VA6zVw/3TOOC46djAnj84DrFIM5bWNPd4+pVTv1GnQN8Z8CpS22DwHeNp+/DRwrt/2Z4xlCZAtIgXA6cACY0ypMaYMWEDrLxLlZ82eCgAGZKc0216QlcJfzpvg6+nnpidRUq1BXykVmK7m9PONMcUA9t/97O0DgV1+x+22t7W3XbUjLz2JvIwkzj2q43+m3PQkDlY19FCrlFK9Xbhv5Eob20wH21ufQORKEVkuIssPHjwY1sb1Jvsr6xlbkElcXFv/dE3yMpIoqdagr5QKTFeD/n47bYP99wF7+25gkN9xhcDeDra3Yox5xBgz1RgzNS8vr4vN6/2q6p2+evkdsdI7DRjT9B1aUt3A4qKS7myeUqqX6mrQnwt4R+BcBrzpt/1SexTPcUCFnf6ZD8wSkT72DdxZ9jbVjuoGN2lJrRdOaSkvIwmn2zS74fvtvy3koseW4tHyDEqpFjqNKiLyAjADyBWR3VijcO4GXhaRK4CdwPn24fOAM4EioBa4HMAYUyoitwPL7OP+bIxpeXNY+alpcJGeFN/pcbnpiQAcrGogO9V6XFnvAqC8zklOWmL3NVIp1et0GvSNMRe2s2tmG8ca4Op2zvME8ERQrYtRbo+hzhlYT98b6FsO7QQ4VN2gQV8p1YzOyI1CNY1WTz09gKDfshRDvdPt2/efJTu6oXVKqd5Mg34Uqmmwgn4gPX3vwuneUgx7yut8+z7Xm7lKqRY06Eeh2kart56a2HlO31uQzVur59Y31/n29c9K7obWKaV6Mw36UcibovFfD7c93p5+Y4vVs8YNyKS6wd3WS5RSMUyDfhRqsCtpJjk6vzy+9I7d03d5PBwztA9D+qZSXd/65q5SKrZp0I9CDU5v0A8gveNbMtF6zYGqBvplJJOe5KBGe/pKqRY6v1Ooepy3rHJyQgA9fXv1LO/onco6F1mpCSQ54nw3hJVSykuDfhRqSu8E3tNvdHmY93UxtY0uUhLiSU2Mp7rRhTEGkY7r9yilYocG/SjkvZGbFEBP3xv0n1u6g3V7KwFISYgnPcmBMdZIoECGfiqlYoPm9KNQMDdyE+0budtKanzbUhLjfYG+tKaRnYdqu6GVSqneSIN+FAouvWNdQu/Yfmjq6QPcOncd0+/5mAOV9d3QUqVUb6NBPwo1OAO/ketoo95+SmJT0P9oo1X1+v31+8PYQqVUb6VBP8I8HsM7a4px+5VB9vb0E4MYp+8vJSG+VR7/881akkEppUE/4t5YuYern/+KZ77Y7tvW6A36bQT0luLjhJadfYNp9iUCMH/9Ptba6+4qpWKXBv0IK6u1FjXfXdZUKM3l8eCIk4CHWrZcK6WwTypTh/bxPZ82NAdj4Oz7P6dax+4rFdM06EeYr3aOq6l2jsttfEMxu+KYoTkkJ8Tz8MVTAMhMcXDZ8UMA2HqwOoTWKqV6Ow36EebN2zv9CqY53cY30zYU8Xbex+0xXHSsFfT9h3YqpWKPBv0I846+eXHZLt82p9vT5Z7+pzed4nt8wshcpg3L4bdnHsnAPikAFFfo0E2lYplO1Ywwl19C3lsyweXx+MbfB+N/vz+RwX1Tfc/Tkxy8/NPjfedOToijpKoh9EYrpXot7elHWIPf8obeoZpWeif4nv4Z4/u3u09EyMtIoqQ6fEF/d1ktf5u/CU/LO8lKqailQT/C/Bc/8Y6scbm71tNP6WTRldz0JEqqG4M+b3vOeWARD3xcxPZDep9Aqd4ipKAvIteLyDoRWSsiL4hIsogME5GlIrJZRF4SkUT72CT7eZG9f2g4PkBv562dD01r4zo9xrfgeTA6+6LITE6gKowLq5TWWF8gVfU6DFSp3qLLQV9EBgLXAlONMeOBeOAC4K/AvcaYUUAZcIX9kiuAMmPMSOBe+7iY1+Bqu6ff1kzbUKUnObplnL4GfaV6j1AjiwNIEREHkAoUA98GXrX3Pw2caz+eYz/H3j9TtNC7b8EUwLfSlTPIcfoXThsc0CLqaUnxYVtNq7axKdCH87cHpVT36nLQN8bsAf4G7MQK9hXACqDcGOONCLuBgfbjgcAu+7Uu+/i+Lc8rIleKyHIRWX7w4MGuNq/X8O/pV9ZZwdPp9uAIYpz+Xd+dwPo/z+70uLQkR9hW09pb3jT0s0pn+SrVa4SS3umD1XsfBgwA0oAz2jjUO7Sjra5rq2EfxphHjDFTjTFT8/Lyutq8XsHjMc1KIh+qsUbWuNxdy+l3Ji3RQY29mlaoiiuaykZ4v6yUUtEvlPTOqcA2Y8xBY4wTeB04Aci20z0AhcBe+/FuYBCAvT8LKA3h/Xu1JVsPMfyWeXyx5RCDcqyJU96RNVbtnfDn9NOSHHgM1DlDT/H4T/LaU17XwZFKqWgSSmTZCRwnIql2bn4msB74GPi+fcxlwJv247n2c+z9H5lwdDl7qcVFVqnjPeV19ElNJCPZwYHKejweE3ROP1DpSVbePxx5fe+SjgVZyVraQalepMszco0xS0XkVeArwAWsBB4B3gFeFJE77G2P2y95HHhWRIqwevgXhNLw3s6/3n1KQjw5aYk8/cUO9lXW4+ym0Tve96xpcJGXkRTSubwF4kbnZ7Bw00G2ldQwLDct5DYqpbpXSGUYjDG3Are22LwVmNbGsfXA+aG83+HEP+inJTl8Nzzmr9vPsNy0gNbH7ep7hmPYptNt/ZLmLRj3y5dW8ebVJ4Z8XqVU99IZuRHiP1g1JTGefX5r2G4rqWlWQydc0v16+qHy9vTPmlAAQHZKQsjnVEp1Pw36EeI/Ezc1IZ56v+cAY/Izwv6e3p7+fR9tDvlcTreH+DhhzlEDyE5NIDUxnrKa8JV4UEp1Dw36EeI/Pj8nLbHV/jPtHnQ4eW/kLio6RF1jaDdzrfsO1upe/TOTeXftPo6/+8OwDAdVSnUfDfoRUu83bPLIgkzf40uPH8Ly359KcifF07rC/5yh9vYb/W42p9izgeudHrbqSB6loprW048Q/57+0Nw0nv/xsXy08QC/P3tst71nv4xk4sRaU7cixAlVjS6Pb+F2h18Z6P0V9YzISw/p3Eqp7qM9/Qjxr7nTNy2RE0bmdmvAB2ukzda7zmJgdkqY0jvWf584v7vSt7+zgR89tUzTPEpFKQ36EeJ/47atnH53yu3iYipuj6G81rpZ63Qb33DNeL+e/obiSj7aeIDNB3QBdqWikQb9CPFfCD2QCpnhVJidwo5DtUG/7v8+3cJRf17Agcp6O6dvBfv4Nlb52qJBX6mopEE/QvyXGOzpCtMTCrPYWVrr67UHauXOcgA+3VxCg7MpvdNW0N9VFvyXilKq+2nQjxC3MQzpm8r2u8/q8ffOz7RKMJTVBnczt59duuHGV1bzwYb9TUHf/tLynheaF2RTSkUPDfoR4vYYX7DsaUkOK53U6PJ0cmRzLesBeZdLPH/qIAAeuWQqFxwziKyUhLDV7VdKhZcO2YwQjzHEtZEW6QneoZbBBn3/EUdgfXEBzB7f3/cby6RB2SzbXhq2FbqUUuGlPf0IiWRP3zvqpmUQ70zLUhH9s5LbPK671uJVSoVOe/oR4vYQuZ6+o2s9ff9ZxL86bTTnTh7Y5nHhXJZRKRVeGvQjxGMM3VAyPyC+nr67a0H/ptPHcPUpI9s9Li3JQWmNjt5RKhppeidCInsjt2s9/Tqnm2OG9ukw4IOmd5SKZhr0IySSN3KTfDn94IJ+Vb0roEJw6ZreUSpqadCPkIjeyI0PfshmcUUd6/ZWMqkwu9NjrZy+jt5RKhpp0I8QtyeCQza7kN7ZXmLl6I8f0bfTY9OT4ml0e4JOHymlup8G/QjxmMgP2fzvyj0Bv8ZbVmFgdkqnx6a1WJbxT3PXccfb64NtplKqG4QU9EUkW0ReFZGNIrJBRI4XkRwRWSAim+2/+9jHiojcJyJFIrJGRKaE5yP0Tm6PabNmTU9ITrAu+5fbSwN+zdtriklOiKMgu+2x+f68Qb+y3irz8NTi7Tz2+Ta9uatUFAi1p/8v4D1jzBHAJGADcDPwoTFmFPCh/RzgDGCU/edK4OEQ37tXi2R6JzXRQV+7nHOgKZhdpbXMGN3PV8KhI96bvTe+srpZNdHxt87HFeQwUaVUeHU56ItIJjAdeBzAGNNojCkH5gBP24c9DZxrP54DPGMsS4BsEQn/QrC9hNsY4iMT8wG4+YwjAOsGbSBqGlz0SUsI6FhvmYdl28soa1HJ89a564JopVIq3ELp6Q8HDgJPishKEXlMRNKAfGNMMYD9dz/7+IHALr/X77a3xSS3p+2SxD3Fu3BLeYCVNmsb3aQmBjaXb9bYfMYWZJIQL5RUWUH/nu9PBGDVrvIutFYpFS6hBH0HMAV42BgzGaihKZXTlrYiXKs19UTkShFZLiLLDx48GELzopvHY5otM9jTMlOsXvs3+6s6TfEYY6hpdPly9Z2JixMuPX4ITrdhwfr9AIzOz+DS44ew81CtLqWoVASFEvR3A7uNMUvt569ifQns96Zt7L8P+B0/yO/1hcDelic1xjxijJlqjJmal5cXQvOim9tE7kYuQJYd9G96dQ3Xvbiyw2PrnG6MgbQgVvgalpsGwL0ffAPAmP4Z5GcmU9XgolHz+kpFTJeDvjFmH7BLRMbYm2YC64G5wGX2tsuAN+3Hc4FL7VE8xwEV3jRQLPJE8EYuQGZyU37+3bX7OjzWO9EqNcCePsCwvDTf42tnjiI5Id53gzfURdmVUl0XasG1XwDPiUgisBW4HOuL5GURuQLYCZxvHzsPOBMoAmrtY2OW2xgckQz6KYFfeu94+2B6+nnpTatoXTVjBNC0FnCd003n83qVUt0hpKBvjFkFTG1j18w2jjXA1aG83+EkkmUYgIBvygLUNNpBP4ievojw6KVT2Vte5+vhp2hPX6mI09LKERLp9E5LHbWn1g7SaUF8UQCcNja/2fMUu6dfq0FfqYjRMgwR4o5gGQavudecyEmjcgGobmx/tqw3vZOaFHh6py3enr7/YixKqZ6lQT9CIrlyltfEwmxmj+8PwPwObuZ6b+QG29NvyT+n//GmAwy9+R0+3nSgk1cppcJJg34EuNwe6p3uiK2c5W9YX2uUzVOLt7e5v9Hl4dHPtgKQFmJP35vbf2X5bp5cZL3f5U8uC+mcSqngREHYiT0/fGQJ1Q2uiKd3wCqVfPzwvr7iaC1d8/xXvlm0ofb0vQupz1291zdPICNZbysp1ZM06EfAih1lQOTTO2CNsvn2Ef3YVVrHwaqGZvtW7CjjfXtGLYSe089NT2KAHfjfWm3Ny6uqd2mOX6kepEG/hzz22Va2l9Q02xYNPX2A0f0zANh+qHn7Wn4JBFJhszPuNkowdFT/p7Le2erfTSnVdRr0e0BFrZM73tnAJU8sbbY9kPVme4K3zHJZTfOKmP5lkVf+4bSwvJfL3RT0B+ekAlDd0H7QP/Guj5jxt4VheW+llAb9HuHNl1fXNx8W6V3BKtKyU638essyyOV1Vruf/8mx9LG/GELlX3dndL71G0Z1B+vpVtnDRbVIm1LhER1R5zBXYQfP+Ljm/9yOSBbU9+Mts1zWIs1SYX8JHD2kT9je63tTCn2P5xw1AGj9ZVhe24jL7Wk2c7dKV91SKix06EQ3M8Zww8urAEhoEeQTo2HMJtakqURHXKv0TlW9i0RHXFhy+V5/OHss1586mqSEOLYcrAZotoxig8vNUX9ewA+mFnLtzFG+7RW1zmZF4pRSXRMdUecw9thn2/hmvxXciivqWVxU4tsXLUFMRMhJTWyV3qlzun0TqsIlPk7ISk0gOSGe9BYLqP/hv2uZescHALy8fDelfl9Ci7eU8JtX1/hGPimlukZ7+t3smSXbmz2/6LGmm7nfnRI9C4dlpyZQWtM8vVPvdJMcxl5+6/e00kob91VS73Tz7JIdzfbvr2waPXT3uxspq3Wyr7Kep380rdvapNThTnv63SzXr8Swv1+dNhpHlKR3wMrrl7fo6dc7PSQndF8bs1ISOPeoATzzxQ62tTEsc9Wupl69937DJ98c5PWvdndbm5Q63EVP1DlMNTg9nHpkPpccN6TZ9nCNhgmXPqmJlLaR3unuYaVzJg+kweXh+aU7AfjnD4/igYsmA7BubyXQNLpo1th88jKS+M1ra7Q8s1JdpOmdblbb6CItKZ7bzhnHNd8eyYWPLmHrwRr6pEZX0O+XmcTHm+oxxiD2pLH6Hgj63mGb3tTO4L6pvhIN3+yrIiFeWHjjDDwG+qQm8P76/fz02RVs2FfJlMHhG1WkVKzQnn43q2l0k5roIC5OyM9MZmB2ChA9wzW9huSkUtvopqS6qbff0M3pHYABWcnNVuQakpNKXoaVEttbUU9OWiLZqYnkpCUiIr4via0HdZauUl2hQb+b1Ta4mgW1i4+10jwj+6VHqkltGmTPjt1dVuvbVu/q/p6+iDDKDuQXHzuYvulJZCQ5yM+0Ar/3S9Krf6ZVu2d/ZX23tkupw5UG/W7k8Rhqne5mC4rPHt+fojvPYERedAV970gab0VNsNI7KT1QKuKaU0YCMLEwC7C+CP5y3gQAhvRNa3ZsSmI8mckODfpKdZHm9LtRndONMZDeojplNI3a8cqyF0q/7a31XH7iMOau3ss3+6sZPyCr29/71LH5rP/z6c2+YGYemc+zV0zzpXP8DeyTyvZDta22K6U6F33R5zDiXVA8mEXII8V/otiG4kqufWElAOk9VO8+NdHhu4HsddKoPPLtdI6/iQOzWLO7vFlBOKVUYEIO+iISLyIrReRt+/kwEVkqIptF5CURSbS3J9nPi+z9Q0N972hX611mMMQ69D0hM6Up6J/xr898j9OSou8La9a4fMprndz82teRbopSvU44evrXARv8nv8VuNcYMwooA66wt18BlBljRgL32scd1npTTz+pnYqfP58xoodb0rlvH9GP70wawGtf7faN71dKBSakoC8ihcBZwGP2cwG+DbxqH/I0cK79eI79HHv/TGn5+/xhprYxPAuK9wQRYdyAzGbbzp5YEDX1gfyJCHfMGU+/jCTe+XpvpJujVK8Sak//n8CvAW9ytS9Qbozxlk3cDXgLzAwEdgHY+yvs43tMWU0jv319TY+N/PAWEgt1mcGe8vuzxjZ7PjzKRhj5y0pNYGJhVqt6QUqpjnW5CyoiZwMHjDErRGSGd3Mbh5oA9vmf90rgSoDBgwd3tXltmnz7AsCadPSPHx4V1nO3pTf19AGmDMlu9vyEET36nRy0PqmJrN1TGelmKNWrhNLTPxE4R0S2Ay9ipXX+CWSLiDfKFQLe3793A4MA7P1ZQGnLkxpjHjHGTDXGTM3Lywuhec01uppGenhXsupu3p5+b7iRC9YauF/+bqbv+eTB2R0cHXk5aVa9IF1VS6nAdTnoG2N+a4wpNMYMBS4APjLGXAx8DHzfPuwy4E378Vz7Ofb+j0wP/rQeqKr3e9zQwZHhUd3g4pFPtwLQN63tSpvRqF9GMh/fOIO515wY1sVTukNeRhKNLg+HWiz+opRqX3eM0/8NcIOIFGHl7B+3tz8O9LW33wDc3A3v3a59FVbQ75eR1CM5/VeX72LzgWrGFmSSEuaFSLrbsNw0JhZGdy8fYNIgq41Lt7b6hVEp1Y6wBH1jzEJjzNn2463GmGnGmJHGmPONMQ329nr7+Uh7/9ZwvHegiu2gP2lQNiXVjbg93ftLRrH9xfLIpUd36/vEsqMGZZOfmcR/V+2JdFNUgGoaXHz7bwtZtl2/qCMlZmbkenv6kwqzcHsMh2q6N8VTUtVIQVYyhX1Su/V9YllCfByj8zN6JF2nwuOb/VVsLanhz2+tj3RTYlbMBP01eypITYz3Vbc8UBlcoNhVWsv1L61iydZDAR1/qKah3VWzVPhkpSRQWafDNnuLOHtqTk8NplCtHfZB/7yHFvHc0h28t7aYk0bl+mq5nH3/59Q7A1t9yRjDxY8t5Y2VewJaqm9DcSWfby6hf1brujEqvLJSEqjQoOhLPycAAB5hSURBVN9reGep6xd15BzWQd/p9rByZzm/e2MtTrfhjPEF9PMr4PXqisDWWm1wedhZalV13FVa1+GxtY0uzvjXZ7g8huF5aR0eq0LnDfo6bLN3qLHrUdUF2OFS4XdYB33vOHmvKYP7kOeXcllUVBLQefx7Jd7g35anFm3j7+9/43t+zJCcQJuquignLRG3x7BDSy33CrV2T9/p1i/pSDksg/72khoaXR6q/YL+TaePYXDfVBL9CovtC3DoZmW9dZ7huWnsraijwdW6l+L2GP701noe/3wbAG9d8y1OHZsfysdQAThzQgEJ8cITi7bxj/c3sb1El1GMZt6fSbfH8I8FVgfJ4zG4tEx2jznsgv6/P9nCjL8t5Na5a31lEE4bm89PThruO+b1q07guOE5rNxZzu1vNx9F4HR72Gn3GmsaXDz66Vbf8LJxA7MwBr7cVoqnxZDPogPVzZ4PzdVROz1hQHYKkwf34ZkvdnDfR0U8+lmPjgRWQViz20q1et334WaMMfzo6WV87+HFGvh7SO8oChOg4oo67n53IwAvfLmLxVuskTYXHTu4WQ9/yuA+HD88lyVbS3n8823ccNpoX934l5bt4vf/Xct/rjiWHaU13DmvqWr0WRMKWLr1EJc8/iUAvzx1FO9+vY8B2cm+4mQXThvM1CF9yIjC6pSHqz6pTf/Wh6p1dm60emdNcbPn8XHCwm8OsnDTQQC2H6phZL/WK6Wp8DqsevpbDzb/1d6b501vYyGQ0/xSL68s38UFj3zBoeoG1u21Cnj9v8eXcuc7G5q9ZkJhFn87f5Lv+T8/2Mym/VV8vOmgL61zy5lH8L2jC8PzgVTQ3lu3j+IK62b7waoGbn1zLRW1OlIkGhRX1JOdmsDqW2fxw6mDcHsMlz+5zLe/RL+we0RUB/2aBhcHg5h44w3y718/vdl2/56g19gBmTx40RQAnlmygyVbS7nk8S954cumRTlqG91kpybw/E+O5aNfnczA7BSmj87jV6eNbvP9r/32SO3hR0B5i6B+/F0fcde8DRxz5wc8/cUO7pynE4GiQXFFHWPyM8hKSeBbo3Jb7S+p1kl2PSGqg/7WkhrOe2hRwMcfqKpHxKod88lNM/js16fw5OXHMKKduvATC61Fv7fZN//WF1u9/LMnFvDKz47nxJF9ueXMIzlhRG6z2vK/mDmKTXfM5qGLp/CX8yYAcMe547lh1pgufU4VGu/Y7+tPbfoy/s+SHb7HLy/fzeItgY3UUl1XVtPIH99cS11j28Mx95bXMyA7BYDTx/XnwmmDyUlL9P0MlejM6k7d9e4GfvbsCl5ZvqvLw5SjPqe/u6yOA1X19MvofKLTwaoG+qQmkhAfx5C+1hj5QTnt31AdmJ1CRpKDKr9RPmeM788D9m8Az/34uHZfm+SI58wJBQCMH5jJhIFZAX0eFX7jCrJYu6eSsyYWcO8H1oiQGr/Ak5IQzwfrD3DCiNa9S9U1xhge+KiIsyYWMDwvHbfHcNFjS9lQXMnEwmy+75fidHsMZbWN7K+s901YTHTEcdd3J3DXdyfg8RjuencDm/ZXt/d2CquUzP99Yg1UeG/dPkbnZzB2QCYJ8cH13aO6p+91y+trOz8IawRNXhClD+LipNWqVtUtxvYHYmJhNof5yo9R7bY54/jv1Scysl86j1zSVODuoYun8M613yIj2eEbH67Co7Smkb8v+IYLH10CwNtr9rLB/k351jfXNvs5umf+Jqbe8QEuj2FAG7PU4+KE44b35Z01eynTMtntenFZ8/Wg5zy4iO8+tDjo80R10B+Tn0FBVjIfbtzf6VT7A5X1LN1WGvTCH31SE5s9n6oTqnqd5IR4jrLLLM8a15+Nt8/mycuP4cwJBYwbkEVqYrzOAA2zMvs+yv7KBtwew1c7ynz7ahrdPL14O2BNxnrJL1iNb+c34utmjqKy3sW8tcVt7lewwu/f2OvrPRVUBVnHKKrTO4mOOP5+/iQuemwpq3eVM310+ytpbdpfBcCcowa2e0xb/v3/jubJRdv48UnDaXC5GZYbvevCqsAkJ8Rzyph+zZ7XtpNnVl1TXtvUIx9xyzwAjhuewxH9M3lq8XZfr/+Kp5ZTVuvkj2ePJT3JweTBfdo837gBmSTGx3U44z3WVdY5mT46j5F56TyxaJtv+zf7qzg6iM5qVAd9gKG5Vm7+5eW7Ogz63puxI4KsdzM0N43b5ozvegNV1EtNjG91c7GsppH7PtrMldOHU5CVEqGW9V6lbaRhpg3N4YZZY/hmfxVvrylmyuBtfLm9lB9MLeRH3xrW4flEhMyUBB1e24HKeheD+6bxx++M5dQj+5Ga5ODcBxexcZ8V9A9VN7D9UC1HD2n7i9UrqtM7gK8q5ttrivF4DB+s38+Pn17Wakas9z9hTlpiq3Oo2Jaa2Dqn/+SibTy5aDt3zdsYoVb1bi2HyQK+wD7IXkPiz2+vx+0xnDgysBvoWSkOrZjagco6J1kpVj/9hJG5TCrMIiPJwaZ9VpbjnAcWBTSzOeqDfnyc+JbF21lay53zNvDBhgO8sbL5aknltU4ykh04gryTrQ5/baV3vCupvfN1MbWNLnYc0po9wSi10zuXnziU+y+czO/POpJs+/7Y1aeM5Hx79E56koNvH9Gv3fP466hMtttjWFxU0qqzFyuMMVTUOcn0mwckIozun8HGfVUYY9hTbk1K3F3WcSXgXhEh/3DWkQBsO1TDZPsL4FevrOaV5bsA2Ly/ipU7y8huYxKWUqmJ8WzcV9UsxXPQngjk9him3L6Ak+9ZyJrd5dQ73Ti1BkynymobSYyP449nj+U7kwbwY7/aVoP7pnLP+ZNY8tuZLP/9qQFPWMxOTWTVrnLO/NdnzeZZANz/0WYuste0iEV7K+pxeUyrhZkmDMziy22lzPzHJ75t2zrpwPSKoO9N8Vz+5DJfj214Xhp3vLOBkuoGZv/rM1bvrgh6vKqKDXkZ1g/K50UlrNpVzt/f38TOQ7Vk2OU56p1WkD/ngUUc8Yf3mHHPQp0d2onyGifZqQkdDlXun5VMckJ8u/tbmnlkP2ob3awvruT3/13L80t3UtvowhjDu1/vA+Ddtfu61N5gZvZHm0aXh7Pu+wzAl/Xw+vFJVkrNvwRNZ/WnekWU9P7QAry/fh+j89O574LJVNQ5+WD9ft8i56ceqaWMVWvX22UzNhZXcu6Di7j/oyK2ltRwil/a4Qa/0hp7yuv4+X9W8ODHRb7/W/4aXR7uXfANFz26pM39saC0tjHs989a/vze8sbXjP3jfG5/e4NvdN6HG/ez5WBwk7gWFZVwzJ0f8KuXV4etrT3pta92U17r5KwJBb5Mh1dhn1QeungKY/Iz+OnJ1m9bpZ2s/93loC8ig0TkYxHZICLrROQ6e3uOiCwQkc32333s7SIi94lIkYisEZEpgb6Xf2/BY6wZlkf0z8ARJ+worSU9ycH/nDCUW848sqsfRx3G0pMcDM5JZf765r3EacNy+NcFR/Hcj4/l5zNGMP+X09l0x2zOmlDAsu1l3DN/U5sL7Vz/8ir+9eFmFm85xG1vrQt42c3DyY5DNRSEeTnQfhlJnDd5IE9efgwpfj/zTyzaxrRhObz9i29hDMz8+ycBL4AE8NDCIsAKnt6hpL3Jwk0HGJidwgMXTSYurvVvVmdOKGD+9dO5efYRJMQLpTUd3wwPpafvAn5ljDkSOA64WkTGAjcDHxpjRgEf2s8BzgBG2X+uBB4O5s2e+dE03+PkhHgc8XEMyknl4YVbqG5wBfVrpIo9Y/pnsHaP9QN//amjOXl0Hqcc0Y85Rw3kxJG5JMTHMaZ/BkmO+Ga/Wf5nyQ7eX7ePeqfbt5i3f4ngZ77YwXcfWkyjK3buA7y5ag/f7K9mYmFwEyE7IyLc+8OjOGVMPxbd/G3euOoExg/M5HtTCnnpyuMYPzDL9xvZH/67lnqnu80FjfzVNbpZVHSIH0wtJD3JwWOfbevw+GjjcntYXHSI6aNzO531LyLkpCWyq5O5Dl0ep2+MKQaK7cdVIrIBGAjMAWbYhz0NLAR+Y29/xlhVgpaISLaIFNjn6dT00XkcWZDJhuJKUhKtAH/G+P48tHALgA71Uh06cURfFqzfD8B3JhVw3amj2j02N70pbfH++v28b7/OX15GEh/fOIOnF2/nnvmb+OSbg83KdR/OrntxFQCzxnXf581JSyQnLZG3f3FSs+3XzhxFckIcf5m3kdPu/QSnyzD/+ulkpbR9s3i7fVPzpFF51DS4WbL1UKtjSqobcMSJb/QRwIbiSmob3Z2Oee9uu8vqqGpwtTupraUzxhfwlD0buj1hyemLyFBgMrAUyPcGcvtvb+J0ILDL72W77W0tz3WliCwXkeUHDx5stu+44dass2SHFfRvOG00T15+DD+fMYLrZrb/Q6zU96cO8j3uLBftnZV9+rh8fnLSMM6aWNAqlXHTrDGkJzn4gX1ebw3/WDAwO4Uj+mcwbkBkigyO7Gddn12ldeyrrGfSbe9z9XNftfnb1td7KgAYnZ/BiLw0iivqmt2HeW9tMVPv+IArn1nR7HVn/OszvvfwYp5buoPaRhe/eXUNzy7Zwfq9PZce8ngMlzyxFIChfQObdHrzGUeQmthx1iPkGbkikg68BvzSGFPZwa8gbe1odRfMGPMI8AjA1KlTm+1v+YPniI/jlDH9mk25V6ot/gvpZHYyhPDMCf1ZeOMMBvZJaTYirMHl5o2v9jB7fH9frzAnLZE4gQOVvXd0CMBf39tITYOLP31nXJt5Y381ja6Ax953hyF+AfCHUwfx0vJdvPN1MSP6pXP9qaMwxiqTXlxRz4MfF5GfmcSofunkpCXiMXCopoEV28s45Yh+vGOPCvpyeykXPbqEJ/7nGBL9rvnv3ljrW+LxJXuIeGJ8HLPH9+f2OePJ6qZh4m6P4doXVrKr1OpMBFppIDkhniF909jQwTEhBX0RScAK+M8ZY163N+/3pm1EpAA4YG/fDQzye3khsDeY9/P+Cue/9KFSgTp9XD7z1+3vNKiJiK/8h78kRzwXTBvcbFt8nJCbnsQDHxdx9NA+va4Dsmx7KRuKK3nYTpMeO6wvZ00soLiijmRHPJkpCcTb/14NLjd3vL2B8lpnmwsT9ZQReen8ZvYRrNhRxp3njeeu707grPs/57UVu/l44wHW7a3Af1DVXd+dQFyckGOPcb9t7nre+bqYlITmhfgWbznEc0t3Mty+9n1SE6hpdNPo8nDqkfms2FFKWa2TRreHuav3Utvo5tFLjw5LhV23x/Dait2cPCaP/MxkVuwo452vrcz3G1edQN8gqgendVdPX6xP+jiwwRjzD79dc4HLgLvtv9/0236NiLwIHAtUBJrP93LZVzJJg77qgocuPrpbJl7NGpfPf5bs5PInl7H1L2d2+qUSTc7/9xfNni/eUsLO0lr++p5VnuJ7Uwr5+w+sJULfXLmXZ+1JU5Eud/LzGSOaPT9tbD73fbjZNysV4JpTRuL0eDhvspVFzrXb7A2mdU43IrDwxhk43R5+/eoabn+7aZW1v5w3gW+NyqWizskAuz6TCByoauDHTy/ngw37+fcnW1u1JVh1jW5+9coq5n29j9z0JOb/8iTuftfqq79x1QkB5/O90tpYHtZfKD39E4FLgK9FZJW97RasYP+yiFwB7ATOt/fNA84EioBa4PJg3/D44X0Bmi3QoFSg4uOE+Ljwj/K6+Ywj+c8Sq3xwWW1jUL2ycNpbXsfmA9Wc3EFhwvYMzklleF4azy1tXrP9ta92c8Os0SwqKuHXr60BrJz+WRMHhKXN4fKtkbnc9+FmAP76vQmcMCK31QJKEwqb7kG88rPj6ZuWSHmd05cuev4nx/H459u4Z/4mAPplJpGRnNBqRnF+ZjKvX3UCZ9/3OR9t3B9y0H/4ky3Ms9NMJdUNnHbvp5TWNHL7nHFBB3yAtKRu6ukbYz6n7Tw9wMw2jjfA1V19P4Dheelsv/usUE6hVNilJzm4/8LJ/OKFlRyqCSzob9xXyfaSGmaPL8DjMXy08QDz1+3jptPH0C+za+PfT7j7IwC23XVmQCkH/yJ0t80ZR2ayg5LqBsYWZHLRsUPITklgxt8WcqJ9XrA+6+e/OSXqFg2aNiyH96+fzrDctHZn5mckJ/Dl72aSnuQgNbF16EtOiOfqU0ZS3eDi4YVbOlytLyE+jmnDcnhj5R7cHsOG4krG9M/oUlUA7xDLX88ew+6yOl74cicFWcn84JhBnbyybW19Nn9RX1pZqd6grz3Ms6S6gdH5GZ0eP/uf1rT67Xefxf0fFfmWeVy85RAv/fQ4Cvu0v8xnW/xHpFTWuQK6wVhSZU3Xv/U7Y333IvyHSLZcg/XK6cO59PghURfwvQL5dw9k2dWbZo3h/KMLO1xqFawvmmeX7PCtJ9A/M5mzJhbYy6dm+0YZdeZAVT2TB2dz1YyRAJwzaQDpSQ6SHF37rTS9G9M7Simbd5nOYGu8/PHNtTzzhZUnv3L6cB75dCt/fW8T9184OeBzvLFyN9e/1FRi4GB1faug7y1OeL49xNQY41uIY1gbN63BuqH96s+OZ+7qvcw8Mr9LaaPeKC5OGJ7XecCeeWQ/Jg3KZvWucgD2Vdbz+OfWv2lGsoOfnTyCcycPZGB26/UajDE8/MkW/vc9K5U0y2+Ox3F2Grurun3IplLKqizpiBNW7CgLavU2b8CfNTafW848kg3FlZ3OqGzpvyutQXADs1PYU17HrXPX8Yezx/L80p0M7ZvGhdMGc9OrVj7+gw37OW/yQF5atouPN1nzYPp3UE5h6tAcpg7VJUTbkpro4PWfn8CX20qZNiyHbSXVzF1dTJ/UBF5atot75m/i3wu3sPCmGb6U34biSvIzk/ls80FfwAc4a2JB2No1sbDj+RPS8le4aDJ16lSzfPnySDdDqYCc++AiNhRX8tUfTut0BMXQm99p9vyRS45m1rj+3PjKat5avZf//f5EzpxQEFCO+Jg7P+CkUbncce54vv/wF6wPor7MvT+cxLlHDYzalE1v9v66fVz5rDXpq39mMkNzU1mytdS3f0BWMudOHshPp48I+3h/EVlhjJna1j7t6SsVJpefOJTrXlzFLW98Tf/MZG48fUybQbvR5SFOrOKBRxZkMu/ab/mCbkFWMg0uD9e9uIrb3lrPrd8Z2+ZvDnWNbp7/cicl1Q0crGqwF4B3MO+6kyg6UMWp//iUCQOzuPU7Y3l44RZy05P487njqGt089aaYtbsKue2OeM6vemnum7GmH5MHpzNyp3l7KusZ19lvW9fckIc//nxsQGlkcJNe/pKhUlZTSOTb1/gez4mP4MHL57MyH7NbzD++a31PLFoG/d8f6Ivx+5VXFHHz55dwerdFb5tZ08s4KJpgzl+RF9EBGMMw347r9nrXvv5Cc3qxOyvrCfJEdesnoyKjAXr97OztJanF2/n5NF53DR7DDUNrm5dm7mjnr4GfaXCaN7XxVz13Fe+55MKs3jt5yf4lvGsqncy4U/vA60DtT+X28MbK/fwu/+u9dWUuXL6cM6ZZI2PP/v+zwG47ZxxTCzM4qhB2ZqiUT6a3lGqh5w5oYBpQ3MYnpfGt0blcs3zK3lq8XbfcoKrd1k9+GtnjmLK4PZLEzvi4zh/6iC+N6WQPeV1XPXcVzzy6VYe+XSr75gn/+eYZgvBKBUIDfpKhdnLPzve9/ixz7ZxxzsbGJ2fwfTReby6YhcZSQ5+dvLwgHrmcXHCoJxUbj93PL9+dTVHD7FGiWw5WMO4AZnd+THUYUqDvlLd6IJjBrFqVzmXPvEl/7rgKOat3ccPpw4K+gbqUYOyef/6k7uplSqWaOUypbrRD48ZxCs/O56slASue3EVjS4P02NkkpOKThr0lepGIsIxQ3P4/DenMGlQNiPy0jh+RGgzLpUKhaZ3lOoBGckJ/PeqE/AYfPXplYoEDfpK9RARIV7jvYowTe8opVQM0aCvlFIxRIO+UkrFEA36SikVQzToK6VUDNGgr5RSMUSDvlJKxZCoLq0sIlXApk4PtGQBFZ0eFdyxkToOIBcoicB794Z/x95yTr3e0fve3XHOaLreY4wxba8Ub4yJ2j/A8iCOfSTcx0bquGA+e4TbeNi8dxR8Hr3evfyc0XS9Ozr/4ZTeeasbjo3UccGIZBsPp/fujnPq9Y7e9+6Oc/aG6x316Z3lpp3VXw53sfzZY5Fe79jS3de7o/NHe0//kUg3IIJi+bPHIr3esaW7r3e754/qnr5SSqnwivaevjqMiUh1J/sXioimPA4Ter2jgwZ9pZSKIVEV9GOxJ9DZZz7cicgMEXnb7/kDIvI/EWxSt9Lrrdc70qIq6CullOpeURf0Y60nACAi6SLyoYh8JSJfi8gce/tQEdkgIo+KyDoReV9EUiLdXhUavd6xJdqud9QF/RhVD5xnjJkCnAL8XUS8C+uNAh40xowDyoHvRaiN3cVF8/+HyZFqSA/S691Er3cPX29dIzc6CPAXEZkOeICBQL69b5sxZpX9eAUwtOeb1612AGNFJAkrAMwEPo9sk7qdXm+93hG73tEY9GOxJ3AxkAccbYxxish2mj53g99xbuCw+HVfRBxAgzFml4i8DKwBNgMrI9uyHqHXW693xK53NAb9WOwJZAEH7P8QpwBDIt2gHjAO2AJgjPk18OuWBxhjZvRwm3qKXm+93hETNUE/FnsC3s8MPAe8JSLLgVXAxog2rJuJyM+Aa4FfRrotPUmvt15vouB6R00ZBhGZBDxqjJkW6bb0lFj8zLFMr3dsidbrHRWjd+yewAvA7yPdlp4Si585lun1ji3RfL2jpqevlFKq+0VFTz8WiMggEfnYnoyxTkSus7fniMgCEdls/93H3n6EiHwhIg0icmOLc11vn2OtiLwgIrEwwqlXCfP1vs6+1utEJKby4r1FF673xSKyxv6z2E4Fec81W0Q2iUiRiNwc7rZq0O85LuBXxpgjgeOAq0VkLHAz8KExZhTwof0coBTr5tff/E8iIgPt7VONMeOBeOCCnvkIKgjhut7jgZ8A04BJwNkiMqpnPoIKQrDXextwsjFmInA7dv17EYkHHgTOAMYCF9rnCRsN+j3EGFNsjPnKflwFbMCapDEHeNo+7GngXPuYA8aYZYCzjdM5gBR7dEAqsLebm6+CFMbrfSSwxBhTa4xxAZ8A5/XAR1BB6ML1XmyMKbO3LwEK7cfTgCJjzFZjTCPwon2OsNGgHwEiMhSYDCwF8o0xxWD9xwH6dfRaY8werN7gTqAYqDDGvN+d7VWhCeV6A2uB6SLSV0RSgTOBQd3XWhWqLlzvK4B37ccDgV1++3bb28JGg34PE5F04DXgl8aYyi68vg/WN/8wYACQJiL/L7ytVOES6vU2xmwA/gosAN4DVmOlElQUCvZ625O1rgB+493UxmFhHW2jQb8HiUgC1n+I54wxr9ub94tIgb2/ADjQyWlOxarXcdAY4wReB07orjarrgvT9cYY87gxZooxZjpW7n9zd7VZdV2w11tEJgKPAXOMMYfszbtp/ptcIWFO32rQ7yF2Vb3HgQ3GmH/47ZoLXGY/vgx4s5NT7QSOE5FU+5wzsfKHKoqE8XojIv3svwcD38Ua/62iSLDX276WrwOXGGO+8Tt+GTBKRIaJSCLWII25YW2rjtPvGSLyLeAz4GusSnsAt2Dl/V4GBmMF9PONMaUi0h9YDmTax1cDY40xlSJyG/BDrF/zVwI/Nsb4F25SERbm6/0Z0BfrJu8NxpgPe/TDqE514Xo/hlVGeYd9rMsYM9U+15nAP7FG5j1hjLkzrG3VoK+UUrFD0ztKKRVDNOgrpVQM0aCvlFIxRIO+UkrFEA36SikVQzToK+VHRNwissqulLhaRG4QkQ5/TkRkqIhc1FNtVCoUGvSVaq7OGHOUMWYccBpWrZtbO3nNUECDvuoVdJy+Un5EpNoYk+73fDjWLMlcrAWtnwXS7N3XGGMWi8gSrGqY27AqKd4H3A3MAJKAB40x/9djH0KpDmjQV8pPy6BvbysDjgCqAI8xpt6uaf+CMWaqiMwAbjTGnG0ffyXQzxhzh4gkAYuwZmJu69EPo1QbHJFugFK9gLfyYQLwgIgcBbiB0e0cPwuYKCLft59nAaOwfhNQKqI06CvVATu948aqjngrsB9rBas4oL69lwG/MMbM75FGKhUEvZGrVDtEJA/4N/CAsfKgWUCxMcYDXIJVEAustE+G30vnAz+3S+0iIqNFJA2looD29JVqLkVEVmGlclxYN269pXIfAl4TkfOBj4Eae/sawCUiq4GngH9hjej5yi65exB7mTylIk1v5CqlVAzR9I5SSsUQDfpKKRVDNOgrpVQM0aCvlFIxRIO+UkrFEA36SikVQzToK6VUDNGgr5RSMeT/A3mNNLLjEi23AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "highs.plot()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2017-07-02</td>\n",
       "      <td>268.066486</td>\n",
       "      <td>271.124595</td>\n",
       "      <td>264.819730</td>\n",
       "      <td>268.202162</td>\n",
       "      <td>2.185035e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2017-07-09</td>\n",
       "      <td>261.337024</td>\n",
       "      <td>262.872917</td>\n",
       "      <td>259.186190</td>\n",
       "      <td>261.062083</td>\n",
       "      <td>1.337349e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2017-07-16</td>\n",
       "      <td>196.193214</td>\n",
       "      <td>199.204405</td>\n",
       "      <td>192.722321</td>\n",
       "      <td>195.698393</td>\n",
       "      <td>2.986756e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2017-07-23</td>\n",
       "      <td>212.351429</td>\n",
       "      <td>215.779286</td>\n",
       "      <td>209.126310</td>\n",
       "      <td>212.783750</td>\n",
       "      <td>4.298593e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2017-07-30</td>\n",
       "      <td>203.496190</td>\n",
       "      <td>205.110357</td>\n",
       "      <td>201.714048</td>\n",
       "      <td>203.309524</td>\n",
       "      <td>1.581729e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-16</td>\n",
       "      <td>255.021667</td>\n",
       "      <td>257.255238</td>\n",
       "      <td>252.679762</td>\n",
       "      <td>255.198452</td>\n",
       "      <td>2.329087e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-23</td>\n",
       "      <td>265.220833</td>\n",
       "      <td>267.263690</td>\n",
       "      <td>262.948512</td>\n",
       "      <td>265.321905</td>\n",
       "      <td>1.826094e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-03-01</td>\n",
       "      <td>236.720536</td>\n",
       "      <td>238.697500</td>\n",
       "      <td>234.208750</td>\n",
       "      <td>236.373988</td>\n",
       "      <td>2.198762e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-03-08</td>\n",
       "      <td>229.923571</td>\n",
       "      <td>231.284583</td>\n",
       "      <td>228.373810</td>\n",
       "      <td>229.817619</td>\n",
       "      <td>1.628910e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-03-15</td>\n",
       "      <td>176.937521</td>\n",
       "      <td>179.979487</td>\n",
       "      <td>172.936239</td>\n",
       "      <td>176.332821</td>\n",
       "      <td>4.259828e+06</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>142 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Open        High         Low       Close        Volume\n",
       "Date                                                                    \n",
       "2017-07-02  268.066486  271.124595  264.819730  268.202162  2.185035e+06\n",
       "2017-07-09  261.337024  262.872917  259.186190  261.062083  1.337349e+06\n",
       "2017-07-16  196.193214  199.204405  192.722321  195.698393  2.986756e+06\n",
       "2017-07-23  212.351429  215.779286  209.126310  212.783750  4.298593e+06\n",
       "2017-07-30  203.496190  205.110357  201.714048  203.309524  1.581729e+06\n",
       "...                ...         ...         ...         ...           ...\n",
       "2020-02-16  255.021667  257.255238  252.679762  255.198452  2.329087e+06\n",
       "2020-02-23  265.220833  267.263690  262.948512  265.321905  1.826094e+06\n",
       "2020-03-01  236.720536  238.697500  234.208750  236.373988  2.198762e+06\n",
       "2020-03-08  229.923571  231.284583  228.373810  229.817619  1.628910e+06\n",
       "2020-03-15  176.937521  179.979487  172.936239  176.332821  4.259828e+06\n",
       "\n",
       "[142 rows x 5 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.resample('W').mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Close</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>2017-07-02</td>\n",
       "      <td>268.202162</td>\n",
       "      <td>293.73</td>\n",
       "      <td>253.23</td>\n",
       "      <td>8.084631e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2017-07-09</td>\n",
       "      <td>261.062083</td>\n",
       "      <td>285.00</td>\n",
       "      <td>231.25</td>\n",
       "      <td>2.246746e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2017-07-16</td>\n",
       "      <td>195.698393</td>\n",
       "      <td>240.33</td>\n",
       "      <td>130.26</td>\n",
       "      <td>5.017750e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2017-07-23</td>\n",
       "      <td>212.783750</td>\n",
       "      <td>249.40</td>\n",
       "      <td>153.25</td>\n",
       "      <td>7.221637e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2017-07-30</td>\n",
       "      <td>203.309524</td>\n",
       "      <td>229.99</td>\n",
       "      <td>178.03</td>\n",
       "      <td>2.657305e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-16</td>\n",
       "      <td>255.198452</td>\n",
       "      <td>290.00</td>\n",
       "      <td>216.31</td>\n",
       "      <td>3.912867e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-02-23</td>\n",
       "      <td>265.321905</td>\n",
       "      <td>287.13</td>\n",
       "      <td>242.36</td>\n",
       "      <td>3.067838e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-03-01</td>\n",
       "      <td>236.373988</td>\n",
       "      <td>278.13</td>\n",
       "      <td>209.26</td>\n",
       "      <td>3.693920e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-03-08</td>\n",
       "      <td>229.817619</td>\n",
       "      <td>253.01</td>\n",
       "      <td>196.00</td>\n",
       "      <td>2.736569e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2020-03-15</td>\n",
       "      <td>176.332821</td>\n",
       "      <td>208.65</td>\n",
       "      <td>90.00</td>\n",
       "      <td>4.983998e+08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>142 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Close    High     Low        Volume\n",
       "Date                                                \n",
       "2017-07-02  268.202162  293.73  253.23  8.084631e+07\n",
       "2017-07-09  261.062083  285.00  231.25  2.246746e+08\n",
       "2017-07-16  195.698393  240.33  130.26  5.017750e+08\n",
       "2017-07-23  212.783750  249.40  153.25  7.221637e+08\n",
       "2017-07-30  203.309524  229.99  178.03  2.657305e+08\n",
       "...                ...     ...     ...           ...\n",
       "2020-02-16  255.198452  290.00  216.31  3.912867e+08\n",
       "2020-02-23  265.321905  287.13  242.36  3.067838e+08\n",
       "2020-03-01  236.373988  278.13  209.26  3.693920e+08\n",
       "2020-03-08  229.817619  253.01  196.00  2.736569e+08\n",
       "2020-03-15  176.332821  208.65   90.00  4.983998e+08\n",
       "\n",
       "[142 rows x 4 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.resample('W').agg({'Close':'mean','High':'max','Low':'min','Volume':'sum'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
